Lookup problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
=IF(ISNA(VLOOKUP(D2,Sheet2!$D$2:$H$20,5,False)),"",VLOOKUP(D2,Sheet2!$D$2:$H
$20,5,False))

and copy down
 
Back
Top