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