0
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!
You deleted your column and row numbers, what appears to be col B only has rows 1,2,3. You need a different screenshot. – Tyson – 2018-09-10T01:29:52.287
@Tyson ok i think the screenshot has been updated. let me know if that helps! thank you! – Anthony – 2018-09-10T01:35:51.430
This REVERS LOOKUP
=VLOOKUP(B6,CHOOSE({1,2},F13:F22,C13:C22),2,0)
will also find the value80
. – Rajesh S – 2018-09-10T04:38:51.727