Lookup problems

[Guest]

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.

 

[Anne Troy]

You only need to post your question in one place.
************
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

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

and copy down