I need help with Array formula??

What price should be if 10.5 width and 40 height ? Does this kind of dimension exist?

10.5 would work, 10 1/2 not so much.

Create a table with height going down the left as row labels, and widths going across the top of the table as headers. Do not enter the "range" as 10-14, just enter that value of the START of each range. When the next range starts, that indicates the prior range has ended. It will look like this:

Please Login or Register  to view this content.

Now you can use an INDEX(Match, Match) formula to get the price from the grid.

Height in A25, Width in B25, this formula in C25:

=INDEX($B$2:$F$6, MATCH(B25, $A$2:$A$6, 1), MATCH(C25, $B$1:$F$1, 1))

I think it would be possible.

A thread title of "two dimensional table lookup" might solicit more relevant repsonses though.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Don't upload a picture when you have a workbook question. None of us is inclined to recreate your data. Upload the workbook and manually add an 'after' situation so that we can see what you expect. In addition clearly explain how you get the results..
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

Step by step instructions in post #3 were exactly right. You just needed to follow them, just put the START of each tier around the table to indicate the ranges. Then the formula as given worked fine. I've cleaned up the first two tables at the top for proper table layout and show an example below them using the data. You can repeat that with the other sections.

Originally Posted by Jacen

Does this account for the fractional (or even decimal) increments between the whole numbers?
i.e. 10 5/8" or 73 1/2"?

Does it work when you try it?

The INDEX and MATCH functions are well-documented in Excel itself. (Press F1 to look them up in the Help Files).

Have her read through Excel's help files on those functions and then post any extended questions here.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.