Return a row label for a text value in an array

[pbody]

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

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

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	F​
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	Week 3	Kohls
12​			Adam	Week 2	Sears
13​			Alyssa	Week 3	Target
14​			Andy	Week 2	Kohls
15​			Brad	Week 3	Sears

In D11 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($B$2:$F$2,1/(1/MIN(IF($B$3:$F$8=$C11,
  COLUMN($B$2:$F$2)-COLUMN($B$2)+1)))),"NA")

In E1 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$3:$A$8,1/(1/MIN(IF($B$3:$F$8=$C11,
  ROW($B$3:$F$8)-ROW($B$3)+1)))),"NA")

<strike></strike>

 

[pbody]

No wonder I couldn't get it....wasn't as close as I thought!

Thanks a ton Aladin....you're a rockstar!

 

[Aladin Akyurek]

No wonder I couldn't get it....wasn't as close as I thought!

Thanks a ton Aladin....you're a rockstar!

You are welcome.