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!

enter image description here

Improve this question
3
  • 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
    Commented Sep 10, 2018 at 1:29
  • @Tyson ok i think the screenshot has been updated. let me know if that helps! thank you!
    – Anthony
    Commented Sep 10, 2018 at 1:35
  • This REVERS LOOKUP =VLOOKUP(B6,CHOOSE({1,2},F13:F22,C13:C22),2,0) will also find the value 80.
    – Rajesh Sinha
    Commented Sep 10, 2018 at 4:38

1 Answer 1

Reset to default
1 
=INDEX(C13:C22,MATCH(B6,INDEX(D13:N22,0,MATCH(B1,D12:N12,0)),0))

POC

It uses MATCH and INDEX instead of HLOOKUP and VLOOKUP

Improve this answer
2
  • Updated the answer to reflect new understanding of the question. I originally thought you were trying to pull a number from the middle of the table, not the left most column. That has been corrected.
    – Forward Ed
    Commented Sep 10, 2018 at 2:56
  • you are the man that worked like a charm!
    – Anthony
    Commented Sep 10, 2018 at 3:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .