Based on your sample file...

To lookup a 2x4 10 ft long:

A10 = 2x4
B1 = 10

=VLOOKUP(A10,A2:O8,MATCH(B10,A2:O2,0),0)

--
Biff
Microsoft Excel MVP


"Gulfman100" wrote in message
...
I am creating a home building estimate program in excel and want to return
the value in a certain cell by giving row and column referances. I created
lists with headers to referance the rows and col. I named the database to
referance it. Everything I try to do to referance the database returns an
error. I have tried the Index function (array style) to retreive the data.
I
suspected that the row and col names have something to do with the problem
so
I tried formatting their cells as text only and that didn't help.

This the database file: http://www.freefilehosting.net/download/3efdg
Thanks in Advance