Thanks Micky,

They both work great! I like the INDEX version because it's easier for me to
see how it works and modify. I can't for the life of me understand how you or
anyone else knows these things. I search help forever trying to learn on my
own before giving up and posting in this forum. I don't know what I would do
without this forum!

Thanks again,
Jeff

"מיכאל (מיקי) אבידן" wrote:

Try:
=INDEX(A1:L1,MATCH(F5,A1:L1,)+1)
OR:
=OFFSET(A1,,MATCH(F5,A1:L1,))
Micky


"Jeff Jensen" wrote:

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