INDEX/MATCH Functions with row-arranged table.

[Bob Keller]

I cannot get standard index/match function to work with following setup:

A B C
1 red green blue
2 x y z

If another cell has red, green, blue as its validated choices, I want
another cell to auto-populate with x, y, or z. All the examples I've seen has
table setup in columns, not rows - but my solution requires the row setup.

Ideas?

- Bob

 

[JMB]

Say E1 contains the value you want to look up, try
=HLOOKUP(E1, A1:C2, 2, 0)

The Index/Match combination should be
=INDEX(A2:C2, MATCH(E1, A1:C1, 0))

If it doesn't work, double check your data to make sure it is actually a
match (maybe trailing spaces or some other characters mixed in)