Re: 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_nodes!A2:A6500=Editorial!A2)*(planning_nodes!G2:G6500=Editorial!D2),0))


"Mike H" wrote:

Try this

=INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="value2"),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
.