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