I am trying to use an index match function in an array to return a value. However, I am getting an error. See example below and the formula I am using.
1 2 3
a red orange yellow
b green blue indigo
I want to return "Blue"
I think this requires an array formula with the critiera "b" and "2" so it knows to return Blue any sugguestions on the formula I would use. My 2 criteria index(match) array function returns an #NA error.
Bookmarks