Index/Match on multiple columns

[Evon]

I have a workbook that contains several tabs. On the first tab I'm
setting up an index function that will look up information from a
range named "May" based on the value in column B of the first tab.
However, what I really need to do is look up information on tab 3
based on the values in columns B and C of the first tab. Can someone
help me with this? Here's my current formula:

=INDEX(May!$C$1:$J$392, MATCH($B2,May!$C$1:$C$392,), MATCH("PRIOR
MONTH CUM HOURS",May!$C$1:$J$1,))

 

[DtTall]

I have a workbook that contains several tabs. On the first tab I'm
setting up an index function that will look up information from a
range named "May" based on the value in column B of the first tab.
However, what I really need to do is look up information on tab 3
based on the values in columns B and C of the first tab. Can someone
help me with this? Here's my current formula:

=INDEX(May!$C$1:$J$392, MATCH($B2,May!$C$1:$C$392,), MATCH("PRIOR
MONTH CUM HOURS",May!$C$1:$J$1,))

I would suggest making a column that cobines B and C so =A1 & " " &
B1 and then look up based on that. You can either do that within the
formula as what to look up, or include it as part of the original
range in a new column.