So I'm not sure if I'm overthinking this or not, but if I want to a find the row label (could also be a column label) for a unique text value within an array. What would my formula be?
I have attached an hypothetical example to illustrate what I am looking to do.
Your help is appreciated...thanks!
So in this example....I want to be able to find the store that Aaron, Adam, Alyssa, Andy, and Brad visited.
Excel 2013
I have attached an hypothetical example to illustrate what I am looking to do.
Your help is appreciated...thanks!
So in this example....I want to be able to find the store that Aaron, Adam, Alyssa, Andy, and Brad visited.
Excel 2013
Row\Col | B | C | D | E | F | G |
---|---|---|---|---|---|---|
2 | | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
3 | Target | Jeff | Mike | Alyssa | Marissa | Jessica |
4 | Walmart | June | Elijah | Brian | Curtis | Melissa |
5 | Sears | John | Adam | Brad | Hank | Jason |
6 | Kohls | Matt | Andy | Aaron | Jeremy | Kevin |
7 | Kmart | Toni | Michelle | Lisa | Liz | Holly |
8 | Macys | Chad | Jennifer | Marie | Nathan | Christy |
9 | ||||||
10 | Name | Week | Store | |||
11 | Aaron | |||||
12 | Adam | |||||
13 | Alyssa | |||||
14 | Andy | |||||
15 | Brad |
Sheet: Sheet1 |