Lookup Function Help

[Furn16]

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]

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.

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)