Evaluate 3 columns of data and display 1 value in a 4th column

[helprb123]

I have a (hopefully) quick excel question.

I have 3 columns of data that look like the following:

Car 1 Match	Car 2 Match	Car 3 Match
#N/A	A	#N/A
#N/A	#N/A	B
#N/A	#N/A	B
S	#N/A	#N/A
A	#N/A	#N/A
#N/A	A	#N/A
S	#N/A	#N/A

This data is in 3 columns because I put in formulas that will extract the car identifier from other sheets with matching information. Now I need only 1 column that displays this information. I need a 4th column that will combine all of the sets so I have the following:

Car 1 Match	Car 2 Match	Car 3 Match	Car
#N/A	A	#N/A	A
#N/A	#N/A	B	B
#N/A	#N/A	B	B
S	#N/A	#N/A	S
A	#N/A	#N/A	A
#N/A	A	#N/A	A
S	#N/A	#N/A	S

I need 1 column that will show me the car identifier. Any thoughts on how to do this?


Thank you!

[ranman256]

=IFNA(IFNA(IFNA("",C1),B1),A1)

[helprb123]

Ranman256 - thank you for your help. However, I received an error when doing this code (#VALUE). Do you know why?

[Paul_Hossler]

=IFERROR(A2,IFERROR(B2,IFERROR(C2,"None")))