Combine comments from four tabs into one column.

are the comments to be concatenated by Equipment Numbers, or some other criterion?

Not concatenated, no.
By combine, I mean all those in tabs 1 - 4 added to the 'All' tab, which is a total.

I have tried IFERROR with VLOOKUP with no success.
Any ideas appreciated.


John.

Any reason why you can't copy and paste them?

OK. The Comments in column F of tabs NE, NW, SE and SW will be added to over time. There will be 300 - 400 rows in each tab, not all the same number in each.
When an entry is made in F, the IF function in G adds the corresponding response.
The tab ALL will be a total of all the four previous tabs. What I need to do is, when an entry is made in either of the F columns, a function in column F in 'ALL' will respond by duplicating the entry, thus in that column will be a combined total of all the other four. I can then use that for progress reporting.

John.

Mate,
That looks superb - thanks very much indeed.
And thanks for spotting the duplicates too.

John.

Please mark this as solved

I have done, Darknation.
I also want to know how I can replace the zeros with empty cells. I have tried using "" and " " plus simply removing the zeros from the function, all to no avail.

John.

"" creates a blank cell. What is the formula that is not working for you?

When I replaced the zeros in this:-
=+IFERROR(INDEX(NE!$F$2:$F$150,MATCH(B3,NE!$B$2:$B$150,0)),IFERROR(INDEX(NW!$F$2:$F$150,MATCH(B3,NW!$B$2:$B$150,0)),IFERROR(INDEX(SE!$F$2:$F$150,MATCH(B3,SE!$B$2:$B$150,0)),IFERROR(INDEX(SW!$F$2:$F$150,MATCH(B3,SW!$B$2:$B$150,0)),""))))
with "", in one sheet it failed to return blank cells.
Tried it in another sheet and it works as anticipated.
Thanks to all for the help with this. I shall start another thread if any more problems arise.

Cheers,
John.