vlookup with 2 values

N

NITESH G

I want to use vlookup function , and lookup 2 values at a time.
Is it possible with Vlookup or any other reference/lookup functions.

Pls suggest.

Thanks in advance
 
B

Biff

Hi!

Providing some (any!) detail would help!

A basic formula for multiple lookup values:

=INDEX(C1:C10,MATCH(1,(A1:A10=Lookup_1)*(B1:B10=Lookup_2),0))

Array entered using the key combo of CTRL,SHIFT,ENTER.

You may not even need a lookup formula but without details how are we
supposed to know?

Biff
 
B

Bob Phillips

=INDEX(C:C,MATCH(val1&val2,A1:A100&B1:B1000,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top