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
[Table="width:, class:head"][tr=bgcolor:#888888][th]_Row\^Col[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td]

​

[/td][td=bgcolor:#DBDBDB]

Week 1​

[/td][td=bgcolor:#DBDBDB]

Week 2​

[/td][td=bgcolor:#DBDBDB]

Week 3​

[/td][td=bgcolor:#DBDBDB]

Week 4​

[/td][td=bgcolor:#DBDBDB]

Week 5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td=bgcolor:#BDD7EE]

Target​

[/td][td]

Jeff​

[/td][td]

Mike​

[/td][td]

Alyssa​

[/td][td]

Marissa​

[/td][td]

Jessica​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td=bgcolor:#BDD7EE]

Walmart​

[/td][td]

June​

[/td][td]

Elijah​

[/td][td]

Brian​

[/td][td]

Curtis​

[/td][td]

Melissa​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td=bgcolor:#BDD7EE]

Sears​

[/td][td]

John​

[/td][td]

Adam​

[/td][td]

Brad​

[/td][td]

Hank​

[/td][td]

Jason​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td=bgcolor:#BDD7EE]

Kohls​

[/td][td]

Matt​

[/td][td]

Andy​

[/td][td]

Aaron​

[/td][td]

Jeremy​

[/td][td]

Kevin​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td=bgcolor:#BDD7EE]

Kmart​

[/td][td]

Toni​

[/td][td]

Michelle​

[/td][td]

Lisa​

[/td][td]

Liz​

[/td][td]

Holly​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td=bgcolor:#BDD7EE]

Macys​

[/td][td]

Chad​

[/td][td]

Jennifer​

[/td][td]

Marie​

[/td][td]

Nathan​

[/td][td]

Christy​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td][/td][td][/td][td]

Name​

[/td][td]

Week​

[/td][td]

Store​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td][/td][td][/td][td]

Aaron​

[/td][td=bgcolor:#FFFF00][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td][/td][td][/td][td]

Adam​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

13​

[/td][td][/td][td][/td][td]

Alyssa​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

14​

[/td][td][/td][td][/td][td]

Andy​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

15​

[/td][td][/td][td][/td][td]

Brad​

[/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[Aladin Akyurek]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][/tr]
[tr][td]

2​

[/td][td][/td][td]Week 1[/td][td]Week 2[/td][td]Week 3[/td][td]Week 4[/td][td]Week 5[/td][/tr]


[tr][td]

3​

[/td][td]Target[/td][td]Jeff[/td][td]Mike[/td][td]Alyssa[/td][td]Marissa[/td][td]Jessica[/td][/tr]


[tr][td]

4​

[/td][td]Walmart[/td][td]June[/td][td]Elijah[/td][td]Brian[/td][td]Curtis[/td][td]Melissa[/td][/tr]


[tr][td]

5​

[/td][td]Sears[/td][td]John[/td][td]Adam[/td][td]Brad[/td][td]Hank[/td][td]Jason[/td][/tr]


[tr][td]

6​

[/td][td]Kohls[/td][td]Matt[/td][td]Andy[/td][td]Aaron[/td][td]Jeremy[/td][td]Kevin[/td][/tr]


[tr][td]

7​

[/td][td]Kmart[/td][td]Toni[/td][td]Michelle[/td][td]Lisa[/td][td]Liz[/td][td]Holly[/td][/tr]


[tr][td]

8​

[/td][td]Macys[/td][td]Chad[/td][td]Jennifer[/td][td]Marie[/td][td]Nathan[/td][td]Christy[/td][/tr]


[tr][td]

9​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr][td]

10​

[/td][td][/td][td][/td][td]Name[/td][td]Week[/td][td]Store[/td][td][/td][/tr]


[tr][td]

11​

[/td][td][/td][td][/td][td]Aaron[/td][td]Week 3[/td][td]Kohls[/td][td][/td][/tr]


[tr][td]

12​

[/td][td][/td][td][/td][td]Adam[/td][td]Week 2[/td][td]Sears[/td][td][/td][/tr]


[tr][td]

13​

[/td][td][/td][td][/td][td]Alyssa[/td][td]Week 3[/td][td]Target[/td][td][/td][/tr]


[tr][td]

14​

[/td][td][/td][td][/td][td]Andy[/td][td]Week 2[/td][td]Kohls[/td][td][/td][/tr]


[tr][td]

15​

[/td][td][/td][td][/td][td]Brad[/td][td]Week 3[/td][td]Sears[/td][td][/td][/tr]
[/table]

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.