Returning a cell value in a database.
 

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. If anyone
can help I will send the file so you could see what I am workin on.

Returning a cell value in a database.
 

.. If anyone can help I will send the file
so you could see what I am workin on.

Rather than taking it offline, you could keep discussions online,
which benefits all, rather than just one.

You could upload your sample* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the direct link which is generated after you upload your sample,
then paste the link into your reply here

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Returning a cell value in a database.
 

Great idea! I have posted the question again with a link to
freefilehosting.net.
Thanks

"Max" wrote:

.. If anyone can help I will send the file
so you could see what I am workin on.

Rather than taking it offline, you could keep discussions online,
which benefits all, rather than just one.

You could upload your sample* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the direct link which is generated after you upload your sample,
then paste the link into your reply here

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---