advanced VLOOKUP command?
 

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

advanced VLOOKUP command?
 

On Wed, 11 Mar 2009 15:44:27 -0700 (PDT), smith06374
wrote:

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

advanced VLOOKUP command?
 

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

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



On Mar 12, 1:46*am, Lars-Åke Aspelin
wrote:
On Wed, 11 Mar 2009 15:44:27 -0700 (PDT), smith06374

wrote:
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