3 different Cell Colors return 3 different values (text)

[brentcook]

I have an array list that uses iferror(index..... to return a value (text) from a column based on the value (letter) in another column on a worksheet. I do this 12 different times to create 12 lists in a different worksheet. The column that contains the letter is color coded with 3 different colors. I was hoping to have a second column for each of the 12 lists that would return one of three values based on the color of the cell?

I have no idea where to even start for this. Does anyone have any ideas? Let me know if you need more info.

Thanks in advance for any help!

Brent

 

[RCBricker]

I have an array list that uses iferror(index..... to return a value (text) from a column based on the value (letter) in another column on a worksheet. I do this 12 different times to create 12 lists in a different worksheet. The column that contains the letter is color coded with 3 different colors. I was hoping to have a second column for each of the 12 lists that would return one of three values based on the color of the cell?

I have no idea where to even start for this. Does anyone have any ideas? Let me know if you need more info.

Thanks in advance for any help!

Brent

could you provide an example of the data set (starting results), and an example of what you want it to do (end results)