Forum Discussion

justin williammee's avatar
justin williammee
Copper Contributor
Feb 22, 2018

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....
Formulas & Functions
Requests
Willy Lau's avatar
Willy Lau
Iron Contributor
Feb 22, 2018
May I know if the following formula fit your need

=IFERROR(vlookup(coke,tableE,49,False),0)
  • justin williammee's avatar
    justin williammee
    Copper Contributor
    Feb 23, 2018

    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?

Resources