Microsoft Office Questions? Ask a IT Expert for Support ASAP
No. I have two worksheets. One worksheet contains the following columns -Product Code, Title, No. of Units; the other worksheet contains the following columns - Product Code, Title, Unit Cost. I need to pull over the costs in the second worksheet to correspond with the titles on the first worksheet.
I want to accomplish this task with a formula that will match thetitle and then pull in the corresponding cost from the second worksheet. I want to be able to accomplish this by performing one task not each one separately as I have over 600 items to match.