I have 4 spreadsheets, each listing different accounts for the 4 qtr of the
year. I'm trying to roll them up into one spreadsheet, and I figure vlookup
is the easiest way after i do subtotals for the different accounts in each
qtr. So i basically have this format:

=vlookup(1st Qtr)+vlookup(2nd Qtr)....(4th Qtr)

Syntax is returning correct values except when there is no value in one fo
the qtrs, it makes the whole thing kick out the dreaded #N/A.

Any thought on how to get aorund this? Would I have to enclose each vlookup
in an IF(ISNA) loop?

Thanks in advance.

-bob