mopey12345
New Member
 Joined
 Nov 26, 2020
 Messages
 31
 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))