lookups based on more than one column
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
|