Forum Discussion
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...
- Check my sample file and comment. Thanks
tonyan in your formula you have "TRUE" for range lookup parameter which is doing an approximate match, which probably means you are always getting a match to something in the first sheet. what happens if you use "FALSE" in each case meaning exact match?
mtarler I need the formula to check each sheet even if it finds data in the previous sheet. add the numbers together. Is there a formula that will do that?
tonyan sorry didn't catch that sum up part. You want to use SUMIF, SUMIFS or SUMPRODUCT functions. Try this:
=SUMIFS('Departure Billed'!$E:$E,'Departure Billed'!$A:$A,$A10) + SUMIFS('Non Signatory Billed'!$E:$E,'Non Signatory Billed'!$A:$A,$A10) + SUMIFS('Customs Billed'!$E:$E,'Customs Billed'!$A:$A,$A10)I changed the ranges to be the entire column E but change back if you need to restrict that range.