Hi there,
I am pretty well versed in using Excel, however I have forgotten
completely how to do use the lookup function. Can anyone advise what i
need to do here to get what i want...?

I have two sheets in my spreadsheet. On one page I have a list of
product codes, along with the year to date sales value for a specific
department.

In the other sheet I have a longer list of product codes for the whole
company. I want to take the value for year to date sales from the first
spreadsheet and place it into a new column beside the product code on
the second spreadsheet.

Can anyone advise me of how best to go about this. I don't know if it's
lookup, vlookup, match... Im banging my head off the wall!

Thanks


--
JosephJohnSmith