find price in a table

[bill1138]

In excel I hace a grid showing prices for items which we lookup size. The first row has width sizes and the first column has length sizes. We use the following to do this lookup.



'=INDEX(Wide,MIN(COUNT(D$144$159),COUNT(D$144$159)-COUNTIF(D$144$159,">="&H162)+1),MIN(COUNT(E$143:W$143),COUNT(E$ 143:W$143)-COUNTIF(E$143:W$143,">="&G162)+1))

[pdebaets]

Did you mean to post this on an Excel board? Also, what is your question?

[bill1138]

I know how to do this in excel and have not idea about access.

We sell window blinds which are sold by width and length. The prices are stored in a grid with the top row being the width and the first column being the length. I have linked to this grid however I have not been able to even start to come up with a querry to get the information from the grid.

Got any ideas?