Vlookups

[Office Junior]

Is it possible to use vlookup across several worksheets, and adding them to
bring back one resulting figure on a separate worksheet. Like consolidating
across into one. Thx in adv.

 

[Pete_UK]

Something like this:

=IF(ISNA(vlookup1),0,vlookup1) + IF(ISNA(vlookup2),0,vlookup2) +
IF(ISNA(vlookup3),0,vlookup3) + etc

where vlookup1 is looking at your first sheet, vlookup2 is looking at
the second sheet and so on.

The ISNA helps to avoid errors if there is no match in a particular
sheet - if you are using Excel 2007 you could use IFERROR.

Hope this helps.

Pete