Hi,
I am working on a large number of sheets, each of them represents each date's report. In one sheet (named as database) I make a table with a list of dates.
I want to obtain data in a cell of a sheet as pointed by the date in that list. The problem is when I used INDIRECT, it gives #REF warning.
My cell which I want to get the information is also not a constant (contain SUM formula). Any suggestion?
Any help would be appreciated.
Iksan
INDIRECT() is the function to use. We need to see your workbook and your formula that is giving the #REF error.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Make sure we can clearly see which cell has your formula you want us to troubleshoot.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks