I have three columns A B C.

I want to put the data in column C that exists in either column A or B. Only one column in A or B will have data.

Examples:

Data in Column A: 123456789

Data in Column B:

Data That Goes in Column C: 123456789

Data in Column A:

Data in Column B: 987654321

Data That Goes in Column C: 987654321

Thank you for that last answer.

I need slight variation on that:

I want to put text in column C based on data that exists in either column A or B. Only one column in A or B will have data. If data is in column A - then text in column C will always be "UPC". If data is in column B - then text in column C will always be "EAN". Column C will carry this formula, columns A & B have formulas that pull data from another tab.

Examples:

Data in Column A: 123456789

Data in Column B:

Data That Goes in Column C: UPC

Data in Column A:

Data in Column B: 987654321

Data That Goes in Column C: "EAN"