Have you tried this?

Create another column to the left of the first column. Concatenate column 2
and column 3 and lookup your value in the new column. You need this new
column to the left of the original data as vlookup assumes the lookup value
is the left hand most column of the data table.


Hope this helps

Chris

"childothe1980s" wrote in message
...
Hello:

I'm not finding the LOOKUP, VLOOKUP, MATCH, and INDEX functions to be very
helpful for what I need.

I have a sheet of three columns. I want to return a value from the first
column based on corresponding values in the second AND third columns. In
other words, the value from column A is an exact match of what is in BOTH
column B AND C.

Is there a function in Excel that will allow for this?

Thanks!

childofthe1980s