Thanks Lars,

Good point: A1:M1 instead of A1:L1 prevents the #REF! error if I type
Orange. Also, I like the match type ,0 rather than , (even though they both
work), it's helpful for a greenhorn like me because it's easier to see and
understand what it's for.

Thanks again,
Jeff

"Lars-Åke Aspelin" wrote:

On Thu, 7 Jan 2010 12:56:01 -0800, 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

Try this formula in cell F5:

=INDEX(A1:M1,MATCH(F4,A1:L1,0)+1)

Hope this helps / Lars-Åke


.