Hi,

I am trying to do a spreadsheet for a budget. I have one tab with the detail 
of the budget with headings in columns for each category of expense, then a 
second tab showing the overall position. On the overall tab the headings 
appear down the left in rows rather than columns as in the detailed tab.

I am therefore doing a lookup function so that the overall pulls the info 
from the detailed tab. This lookup function works for some of the columns on 
the detailed tab but not all of them. All of the columns have values in them, 
so it's not that there is no data to retrieve. 

Any ideas why it is displaying #N/A on some cells?

Thanks

We would need a little more info plus your formula, however, N/A is
shown if the value isn't present, for tips on evaluating the parts of
your formula and combatting N/A and other errors see this tutorial thats
just been started http://tinyurl.com/ydvv3b8 it should help you
understand your formula better.

Furn16;578275 Wrote: 
> Hi,
> 
> I am trying to do a spreadsheet for a budget. I have one tab with the
> detail
> of the budget with headings in columns for each category of expense,
> then a
> second tab showing the overall position. On the overall tab the
> headings
> appear down the left in rows rather than columns as in the detailed
> tab.
> 
> I am therefore doing a lookup function so that the overall pulls the
> info
> from the detailed tab. This lookup function works for some of the
> columns on
> the detailed tab but not all of them. All of the columns have values in
> them,
> so it's not that there is no data to retrieve.
> 
> Any ideas why it is displaying #N/A on some cells?
> 
> Thanks


-- 
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=159849

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]