How to vlookup/hlookup in microsoft excel?

Posted on


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!

enter image description here




It uses MATCH and INDEX instead of HLOOKUP and VLOOKUP

Leave a Reply

Your email address will not be published. Required fields are marked *