vlookup with 2 values

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

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

"NITESH G" <NITESH.G.1y61da_1131432601.3839@excelforum-nospam.com> wrote in
message news:NITESH.G.1y61da_1131432601.3839@excelforum-nospam.com...
>
> 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
>
>
> --
> NITESH G
> ------------------------------------------------------------------------
> NITESH G's Profile:
> http://www.excelforum.com/member.php...o&userid=17590
> View this thread: http://www.excelforum.com/showthread...hreadid=483041
>

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

--

HTH

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


"NITESH G" <NITESH.G.1y61da_1131432601.3839@excelforum-nospam.com> wrote in
message news:NITESH.G.1y61da_1131432601.3839@excelforum-nospam.com...
>
> 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
>
>
> --
> NITESH G
> ------------------------------------------------------------------------
> NITESH G's Profile:
http://www.excelforum.com/member.php...o&userid=17590
> View this thread: http://www.excelforum.com/showthread...hreadid=483041
>