Vlookup with multiple variables
 

How do I do a vlookup which will match multple variables?

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?

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?

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?

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?

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?

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?

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?

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?

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