Index and Match Functions Help

Hello members, this is my first post so nice to meet you all!

I have an excel table displaying prices based on width, and height.

For example, in cells A1 to A10 there are width ranges. In cells G1 - G10 there are the prices that match each width range.

But if for example the height is up to 2.24 there's a certain price. If it's more, there's a different price.

I want to create a cell that when I input the width (for example 1) and height (for example 2.1) it automatically displays the correct price in a third cell.

Is there any way to achieve that without vba coding (I have figured everything out with vba), maybe with the index, match, or vlookup functions?

Thank you in advance for your response.

Xaric

Welcome to the forum.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

there you go!

Thank you very much for the help!

I've set up a little table for you on the second sheet, where you can enter the width in B1 and height in B2, and I have used this formula in B3:

=IFERROR(VLOOKUP(B1,'ΠΟΡΤΕΣ ΦΥΣΑΡΜΟΝΙΚΕΣ'!$B$13:$K$36,IF(B2<=2.24,6,IF(B2<=2.54,8,10))),"")

which should get translated to suit your (regional) version of XL when you open it.

Hope this helps.

Pete

Thank you very much Pete, it kind of works but it needs some more work. I'll try to figure it out by myself and I'll let you know if I need any further help.

Thanks again,

Xaric