|Subject:||LOOKUP Question [again!]|
|Date:||Wed, 31 May 2006|
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.