Two-way lookup with INDEX and MATCH return closest match

I'm working on a spreadsheet and have run into a issue using Two-way lookup with INDEX and MATCH. If the value is not in the table, I need excel to use the next highest value. However, if the exact number is in the table, I need it to use that number. Below is the formula I'm using.

=INDEX('LarsonTable'!B4:K54,MATCH(Work!F20,'LarsonTable'!A4:A54,1),MATCH(Work!F16,'LarsonTable'!B3:K3,1))

This formula is not showing the next highest number. It is showing the lower number. I tired using the below formula, but it's adding "1" even if it's a exact match

=INDEX(LarsonTable!B4:K54,MATCH(Work!F20,LarsonTable!A4:A54,1)+1*ISNA(MATCH(Work!F20,LarsonTable!A4:A54,0)),MATCH(Work!F16,LarsonTable!B3:K3,1)+1*ISNA(MATCH(Work!F16,LarsonTable!B3:K3,0)))


Below is my criteria

Width 7/8
UI 25

Table where information is pulled
UI Width
1/2" 1"
20 4.0 4.3
22 4.3 4.7
24 4.7 5.0
26 5.0 5.3
28 5.3 5.7

In this example, I need to use the UI of 26 and the Width of 1", to get a Width of Molding of 5.3. My current formula is pulling the UI of 24 and the Width of 1/2" making me have a Width of Molding of 4.7.
If I have a UI of 28 and a width of 1/2", I need to use the exact value which will equal Width of Molding of 5.3

Thanks,

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try this

Formula:

Please Login or Register  to view this content.

where the values 1/2'' and 1'' are written with a single quote twice (code 039 not double quote code 112)
See the file to clarification

Thanks for you input. I'm still having issues with the formula. I have attached the actual file for your convenience. For product number 246350 and a Frame size of 11 X 14, the Inches is 25. Since there is no 25 on the LJT, I need to use the next highest number which is 26. The frame width for this product number is 7/8" and I need to use 1". So the Width of Molding in Inches should be 5.3, not 4.7. Which will make the total wholesale price $14.70 not $13.82 as indicated.

Also, if I use Product number 431485 with a Frame size of 30 X 40, the United Inches will be 70. Since the chart has both 1 1/2" and 70, the Width of Molding would be 13.3. But in the same example if I change the Frame size to 11 X 14 , which will make the united inches 25, I will need to use 26 united inches with the 1 1/2'' Width of Molding.

I hope this make sense.

Hi
You can use this formula in F21

Formula:

Please Login or Register  to view this content.

but @MrShorty proposed a better solution if you can use the sorted table LJT!A3:K54 in descending order as I do in LJTNew in both directions
Formula using LJTNew .

Formula:

Please Login or Register  to view this content.

See the file

Hi @MrShorty

I implemented both solutions using a new LJT sheet called LJTnew in the file I attached in Post # 6, to avoid any problems.
LJTNew has the ordered table as you proposed and the spreadsheet has my formula and your formula is in a parallel cell, because I think your solution is better than mine.
I do not know if it can be used by keeping both sheets using one for one propose and another for other propose.

Thanks for all the help........