View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Keller Bob Keller is offline
external usenet poster
 
Posts: 1
Default INDEX/MATCH Functions with row-arranged table.

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