=VLOOKUP(DU52,Sheet2!A:D,4,False)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"MIKEYH" wrote in message
...
Hi

Can anyone advise me on how to use VLOOKUP when the data to be 'looked up'
is on another worksheet in the same workbook. I also need to be able to
look
up a series of Lookup values in a given VLOOKUP formula, i.e. I need to
write
a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column
A
and return the values found in column D on the rows corresponding to the
values foundin column A.

I hope this makes sense, as this is my first question on these forums.

Thanks in advance.

Cheers

MikeyH