LOOKUP Question [again!]

Giganews Newsgroups
Subject: LOOKUP Question [again!]
Posted by:  shakey1181
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.

Thanks again

Replies