Linking/adding items from like sheets
 

I want to link info from two tabs (sheets) in excel into another Tab (sheet).
Say I want every time that the word GREEN is in a Row in (Tab 1) and GREEN
is in (Tab 2) That GREEN is placed in Tab 3 . Does this make sense. I have
two reports with some data that is dublicate (Or I want to find out which
items are dublicated in both tabs). How would I do this. I want to capute
the results. any help?

Linking/adding items from like sheets
 

Farmer Ted wrote:
I want to link info from two tabs (sheets) in excel into another Tab (sheet).
Say I want every time that the word GREEN is in a Row in (Tab 1) and GREEN
is in (Tab 2) That GREEN is placed in Tab 3 . Does this make sense. I have
two reports with some data that is dublicate (Or I want to find out which
items are dublicated in both tabs). How would I do this. I want to capute
the results. any help?

Assuming your data is in column A of Sheet1 and Sheet2, you could put
this formula in a convenient column of Sheet3:

=VLOOKUP(Sheet2!A1,Sheet1!A:A,1,false)

then fill down as many rows as you have data in Sheet2.

Anywhere you do not see #N/A means the value displayed appears somewhere
in both Sheet1 and Sheet2.