Vlookups
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. |
Vlookups
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 On Mar 30, 7:43*pm, Office Junior wrote: 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. |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com