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?