A1 thru L1 has: Red, Blue, Yellow, White, Black, Gold, Brown, Grey, Purple,
Green, Pink, Orange

I want to be able to type "White" (or any color) in F4 and have F5 display
the value of the next column in the same row where white is, in this case
"Black".

What formula would I need to put in F5?

Thank you,
Jeff