Look up problem
 

Hi
Id appreciate any advice on this lookup issue please.
Basically I have 2 worksheets in a workbook. Both have the same data in
column D, and I would like to set a lookup in Sheet 1, to look into Sheet 2
and where column D data matches in each sheet return the Value from Sheet 2
column H into a new cell in Sheet 1.
Does this make sense? Im sure it should be a simple task, but so far Ive
not had any luck.
Thanks in advance.

=vlookup(d2,Sheet2!$D$1:$H$1000,5,False)

That should look in D1 to H1000 (change as necessary), find the value from
this worksheet's cell D2, and return the 5th column (H) value from sheet2.
The false means to find the exact value, and not a "close" value.

Reference:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"JaB" wrote in message
...
Hi
Id appreciate any advice on this lookup issue please.
Basically I have 2 worksheets in a workbook. Both have the same data in
column D, and I would like to set a lookup in Sheet 1, to look into Sheet
2
and where column D data matches in each sheet return the Value from Sheet
2
column H into a new cell in Sheet 1.
Does this make sense? Im sure it should be a simple task, but so far Ive
not had any luck.
Thanks in advance.