Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUPS | Excel Discussion (Misc queries) | |||
Vlookups | Excel Worksheet Functions | |||
vlookups | Excel Discussion (Misc queries) | |||
Vlookups | Excel Discussion (Misc queries) | |||
vlookups | Excel Worksheet Functions |