Hi,
I would like to enter one of the green values of the table (text) and get the row header for that value. All values of the table are different.
New Picture.jpg
Thanks!
Hi,
I would like to enter one of the green values of the table (text) and get the row header for that value. All values of the table are different.
New Picture.jpg
Thanks!
Last edited by Gerardo83; 01-14-2015 at 07:18 PM.
How do you get 6 for the result? Shouldn't that be a 4?
Post sample workbooks, not pictures
Ben Van Johnson
Array enter this formula in K2:
It produces this:Formula:Please Login or Register to view this content.
Row\Col A B C D E F G H I J K 1 1A1 B1 C1 D1 E1 Ref Result 2 2A2 B2 C2 D2 E2 C7 7 3 3A3 B3 C3 D3 E3 4 4A4 B4 C4 D4 E4 5 5A5 B5 C5 D5 E5 6 6A6 B6 C6 D6 E6 7 7A7 B7 C7 D7 E7 8 8A8 B8 C8 D8 E8 9 9A9 B9 C9 D9 E9 10 10A10 B10 C10 D10 E10 11
Array formulas must be committed by pressing Ctrl + Shift + Enter
Will do.
It works! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks