Forum Discussion

tonyan's avatar
tonyan
Copper Contributor
Nov 02, 2020
Solved

Iferror and vlookup in a formula to combine data from multiple sheets into a one sheet

I notice that my formula is only check one sheet retrieve the data and stop. It does not check the other sheets and pull that data to added to one sheet. For example, looking up item that is on two s...
excel
  • Ilgar_Zarbaliyev's avatar
    Ilgar_Zarbaliyev
    Nov 02, 2020
    Check my sample file and comment. Thanks
    • Ilgar_Zarbaliyev's avatar
      Ilgar_Zarbaliyev
      MCT
      Nov 02, 2020
      Check my sample file and comment. Thanks
    • mtarler's avatar
      mtarler
      Silver Contributor
      Nov 02, 2020

      tonyan  In your sample sheet I used a combination of absolute and relative ranges so you can easily fill down and fill right to fill the whole table.  NOTE that creating a pivot table or using power query may have advantages instead of creating a table of equations.  But for now here is the equation for your sample sheet:

      =SUMIFS(Customs!C:C,Customs!$A:$A,$A3)+SUMIFS(Signatory!C:C,Customs!$A:$A,$A3)+SUMIFS(Depart!C:C,Customs!$A:$A,$A3)
      • tonyan's avatar
        tonyan
        Copper Contributor
        Nov 03, 2020
        I use the Sumifs and that work great! Thanks

Resources