Ooops!
Typo:
To lookup a 2x4 10 ft long:
A10 = 2x4
B1 = 10
Should be:
To lookup a 2x4 10 ft long:
A10 = 2x4
B10 = 10
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
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