Help required with Consolidating Data
 

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

Depends on how your data is laid out. If you use =vlookup(), then the key has
to be in the leftmost column of the table.

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

JosephJohnSmith wrote:

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

--

Dave Peterson