=Index(sheet1!R1:R30,Match(A1&B1&C1,Sheet1!F1:F30& Sheet1!M1:M30&Sheet1!Z1:Z3
0,0),1)

entered with Ctrl+Shift+Enter

--
Regards,
Tom Ogilvy


"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