shakey1181 wrote:
Apologies for another query, I have managed to get around the last
one, so thanks to all who helped.

I'm still struggling with the LOOKUP Function. I need to do a 'double'
vlookup so for example,

A1 = 01/01/06
B1 = 23
C1 = 250

how do i set the lookup so it returns C1 only if A1 and B1 are
correct? I have tried using two sets of vlookup at once, but without
success.

Thanks again

Look back in this forum to find Bob Phillips' reply to the Thread "Lookup
for concatenated data"