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

tonyan 

 

Dear Tonyan,

 

I just tried to understand your query. As far as I understand well, I made a dynamic table which you can find attached. The table is consisted of three sheets (same sheet names like yours). Also, I made one Summary Sheet. I found sales amounts based upon sales data for each sheet and made it shown on different columns. Later, I summed them up.

It is very possible that I don't answer to your question directly, However, I can tell you that in my opinion it is the best way to find the lookup data separately and sum them up.
As for your formula, I didn't understand why you are looking for close numbers like indicating "true". 

 

Good luck.

P.S.
=IFERROR(VLOOKUP(A2,DeparturBilled!$B$2:$E$51,4,FALSE),"")

=IFERROR(VLOOKUP(A2,'Non-SignatoryBilled'!$B$2:$E$51,4,FALSE),"")

=IFERROR(VLOOKUP(A2,CustomsBilled!$B$2:$E$51,4,FALSE),"")

 

 

Resources