QUESTION :
I have a relatively simple formula that I can not figure out.
I need to use B1 and B6 to return a value in B7.
B1 needs to match the value in row 12. Then using only that column of the matched value, it needs to search the numbers below to match B6 (or the closest value). Once that number is found, it needs to return correct value in column C.
Any help is greatly appreciated!
ANSWER :
=INDEX(C13:C22,MATCH(B6,INDEX(D13:N22,0,MATCH(B1,D12:N12,0)),0))
It uses MATCH and INDEX instead of HLOOKUP and VLOOKUP