J
Julia
In this example I put the table you selected in cells
A1:E5. The user would type the height in cell A9 and the
width in B9. In C9 I put this formula:
=VLOOKUP($B9,$A$1:$E$5,MATCH($A9,$A$1:$E$1,0),FALSE)
If there are a list of sizes to be typed running
downwards from A9:B9, you can copy and paste the formula
down from C9.
Lastly, if A9 or B9 is empty or contains a value that
doesn't match the list, C9 will return #N/A.
Hope this helps!
Julia
A1:E5. The user would type the height in cell A9 and the
width in B9. In C9 I put this formula:
=VLOOKUP($B9,$A$1:$E$5,MATCH($A9,$A$1:$E$1,0),FALSE)
If there are a list of sizes to be typed running
downwards from A9:B9, you can copy and paste the formula
down from C9.
Lastly, if A9 or B9 is empty or contains a value that
doesn't match the list, C9 will return #N/A.
Hope this helps!
Julia