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.