Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
How do I do a vlookup which will match multple variables?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Need some details!
-- Biff Microsoft Excel MVP "Sam" wrote in message ... How do I do a vlookup which will match multple variables? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Try this
=INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
I tried the formula you suggested, but received #N/A. Is there something
wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Sam
Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
What do the 1 and 0 do in the formula?
"Mike H" wrote: Sam Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
I did the Ctrl+Shift+Enter and still got the error message.
Any other suggestions? "Mike H" wrote: Sam Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Oops! My error. It works.
Thanks. "Mike H" wrote: Sam Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Hi Mike. It worked, but when I went to lock in the columns to drag the
formula down, I received an error message. How do I lock the columns? Thanks. "Mike H" wrote: Sam Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple variables
Maybe you want:
=INDEX(planning_nodes!$C$2:$C$6500, MATCH(1,(planning_nodes!$A$2:$A$6500=Editorial!$A2 ) *(planning_nodes!$G$2:$G$6500=Editorial!$D2),0)) Sam wrote: Hi Mike. It worked, but when I went to lock in the columns to drag the formula down, I received an error message. How do I lock the columns? Thanks. "Mike H" wrote: Sam Enter as an array with Ctrl+Shift+Enter and Excel will put curly brackets around it {} and it works fine for me. You CANT type the curly brackets yourself Mike "Sam" wrote: I tried the formula you suggested, but received #N/A. Is there something wrong with my formula? =INDEX(planning_nodes!C2:C6500,MATCH(1,(planning_n odes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G65 00=Editorial!D2),0)) "Mike H" wrote: Try this =INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="v alue2"),0)) where a1 - A10 is the value to return and the other 2 columns are the lookup values Mike "Sam" wrote: How do I do a vlookup which will match multple variables? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup multiple variables | Excel Discussion (Misc queries) | |||
VLOOKUP - TWO Variables | Excel Discussion (Misc queries) | |||
VLOOKUP - Two Variables | Excel Discussion (Misc queries) | |||
vlookup Variables | Excel Worksheet Functions | |||
Please Help! vlookup & match with multiple variables | Excel Worksheet Functions |