LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default 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.

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

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Returning a cell value in a database. Gulfman100 New Users to Excel 2 April 2nd 08 03:12 AM
Returning Cell Contents of One Cell Based On Another Cell DallasLDY Excel Worksheet Functions 5 January 31st 07 11:00 PM
vlookup is returning a value one cell above the correct cell. dbaker4 Excel Worksheet Functions 4 April 20th 06 08:21 PM
Returning Cell Value if someone deletes the contents of a cell mmc308 Excel Worksheet Functions 4 March 31st 06 06:41 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"