Selecting row then closest value from it

[ekaz41]

Hello,

My data set has rows that are states: IA, IL, MN, MT, ND, NE< SD, and WI. Each column is a percentile: P1 - P100. I have a value and a state, I want to look-up the state and return the closest value. I have been running into issues because I have not found any formula that will both select the proper row then find the closest value from that row. Thanks!

(columns go to CY)

 

[WassimN]

Hello ekaz41

The closest value to what? the closest to the percentie in the Columns or???

Thanks for any clarifications.

 

[ekaz41]

Closet value to the 118.82 number. So it needs to use the WI row then return the closet value in that row.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...rn-closest-value-from-a-list.html#post4872158

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[ekaz41]

cross post: https://www.excelforum.com/excel-fo...ying-to-return-closest-value-from-a-list.html