find the intersection of a table

[robertdseals]

Hello,
I have a table in cells v20-AG30. Column v20-30 has unique numbers 405,367,328, 289 down to 125. Row V20 - AG20 has percentages 11%, 11.8%, 12.6% etc). In cell D4 I have a number is not an exact match, but falls inbetween the numbers in V20-30 and in E4 I have a number that isn't an exact match, but that fits between the V20-AG20. I would like to write a formula that finds the number at the intersection.

 

[Sam_D_Ben]

Are you looking for something like this -

"=INDEX($K$5:$U$13,MATCH(VLOOKUP($D$4,SORT($J$5:$J$13,1),1,TRUE),$J$5:$J$13,0),MATCH($E$4,$K$4:$U$4,1))"

 

[robertdseals]

Yes (and no). haha. I forgot to mention I'm on Excel 2019 and I don't get to "sort". I'll open it in 365. Thanks!

 

[Sam_D_Ben]

You're welcome!