Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- 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 |
#2
|
|||
|
|||
vlookup with 2 values
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=Lo okup_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" wrote in message ... 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 |
#3
|
|||
|
|||
vlookup with 2 values
=INDEX(C:C,MATCH(val1&val2,A1:A100&B1:B1000,0)
-- HTH RP (remove nothere from the email address if mailing direct) "NITESH G" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
vlookup returning multiple values | Excel Worksheet Functions | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |