Offset Match Formula Problems

[jmuscat]

I have a pricing table showing different widths and heights with the pricing in the column header. This was created through a pivot table. Table ref A18:K18
I need to compare width and height from another table D885:e885 with the pricing table and return the correct price in f885 match against height and width, which is in the column header.
this is the formula i am using
=OFFSET(A895,MATCH(D885,A896:A904,0),MATCH(E885,B895:K895,0))
I am getting a n/a error.
Any help would be appreciated
JMuscat

 

[xlhelp]

It's the Zero in your formula that's causing the problem. Try 1 or -1. That will give an approximate value not an exact value.

If you still get an error after that, then the values you are referring to are text and not numbers.