mopey12345
Board Regular
- Joined
- Nov 26, 2020
- Messages
- 76
- Office Version
- 2010
- Platform
- Windows
I have 5 named tables W1T,W2T,W3T,W4T,W5T each on a separate sheet which has a variable a list of names in column A . I need to add items from each occurrence of the same name from the 5 tables on a summary sheet. This formula works but can it be simplified, or would a VBA routine be better? Thanks in advance Phil =SUM(IFERROR(VLOOKUP($A2,W1T,6,FALSE),0),IFERROR(VLOOKUP($A2,W2T,6,FALSE),0),IFERROR(VLOOKUP($A2,W3T,6,FALSE),0),IFERROR(VLOOKUP($A2,W4T,6,FALSE),0),IFERROR(VLOOKUP($A2,W5T,6,FALSE),0))