Lookup problems
 

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.

You only need to post your question in one place. :)
************
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.

=IF(ISNA(VLOOKUP(D2,Sheet2!$D$2:$H$20,5,False)),"" ,VLOOKUP(D2,Sheet2!$D$2:$H
$20,5,False))

and copy down

--
HTH

Bob Phillips

"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.