Search query

[maldonadocj]

Hello,

I am trying to create a formula that will create a comprehensive listing of unique data points from two different sheets.


For example:

Sheet 1: "Apple" in Cell A1, "Pear" in Cell A2, "Banana" in Cell A3

Sheet 2: "Apple" in Cell B1, "Orange" in Cell B2, "Pineapple" in Cell B3


On Sheet 3:
The formula in Column A should do the following:

If "Pear" exists in Column A of Sheet1 and Sheet2, then note "Pear" as the output.

If "Pear" exists in Sheet 1 but does not exist in Sheet 2, then note "Pear" also in the output.

If "Pear" exists in Sheet 2 but does not exist in Sheet 1, then note "Pear"
also in the output.

I hope I was able to explain this clearly. Your help is greatly appreciated.

Thank you.

 

[maldonadocj]

Hello,

Pls. note that there was a typo...

In the scenario :

"If "Pear" exists in Column A of Sheet1 and Sheet2, then note "Pear" as the output."

It should state "and Column B" in statement:

"If "Pear" exists in Column A of Sheet1 and Column B of Sheet2, then note "Pear" as the output.