PDA

View Full Version : Evaluate 3 columns of data and display 1 value in a 4th column



helprb123
08-11-2014, 12:00 PM
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
08-11-2014, 01:09 PM
=IFNA(IFNA(IFNA("",C1),B1),A1)

helprb123
08-11-2014, 01:26 PM
Ranman256 - thank you for your help. However, I received an error when doing this code (#VALUE). Do you know why?

Paul_Hossler
08-12-2014, 12:24 PM
=IFERROR(A2,IFERROR(B2,IFERROR(C2,"None")))