advanced VLOOKUP command?

[smith06374]

Is there a way to use the vlookup function to look for two values in
one table (lets say, columns A&B) and return the value in column C?

For example
Column A Column B Column C
Big Blue =VLOOKUP
(???????????????) so that "Bird" is returned

source
Column X Column Y Column Z
Big Blue Bird

 

[Lars-Åke Aspelin]

Is there a way to use the vlookup function to look for two values in
one table (lets say, columns A&B) and return the value in column C?

For example
Column A Column B Column C
Big Blue =VLOOKUP
(???????????????) so that "Bird" is returned

source
Column X Column Y Column Z
Big Blue Bird

Try this formula in cell C1

=INDEX(Z1:Z100,MATCH(A1&B1,X1:X100&Y1:Y100,0))

Note: This is an array formula that should be entered with
CTRL+SHIFT+ENTER rather than just ENTER.

Change the100 to fit the size of your source data in columns X, Y, Z.

Hope this helps / Lars-Åke

 

[smith06374]

THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!!!

You just saved me a couple hours worth of tedious mind-numbing work!