Forum Discussion
VLOOKUP with IF function across multiple tables
I have a total sold column in each of the 10 tables i have in my workbook (each on a different tab). Not all tables contain the same items but most do. For example "Coke" may be on 5 of the 7 tables....
May I know if the following formula fit your need
=IFERROR(vlookup(coke,tableE,49,False),0)
=IFERROR(vlookup(coke,tableE,49,False),0)
I think it does, I am not getting any errors. Is there anything wrong with having more than 7 of these stung together with a + sign, in one cell?