Look up value in a table, Return corresponding header

[ydyang2]

https://docs.google.com/spreadsheet...I4W0mNoC86BowudvMW37PBlFvXo/edit?usp=sharingI have an issue here i need to look up a value in a table of information and return the header title of the column that the value is located in.Is there a formula to do this of should i change the formating of the table to align with a formula that could work.I'm not too strong at excel/sheets just yet.Thanks,

 

[Aladin Akyurek]

It should not be that difficult to create a scaled-down sample and post it here along with the desired results.

Sheet1

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

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

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

1​

[/td][td]Business Services[/td][td]Financial Services[/td][td]Information Technology[/td][td]International Business[/td][/tr]
[tr][td]

2​

[/td][td]Eventbrite.com[/td][td]Paypal.com[/td][td]Zdnet.com[/td][td]Alibaba.com[/td][/tr]
[tr][td]

3​

[/td][td]Webex.com[/td][td]Https://www.chase.com/[/td][td]Dice.com[/td][td]Bbs.fobshanghai.com[/td][/tr]
[tr][td]

4​

[/td][td]Freelancer.com[/td][td]Bankofamerica.com[/td][td]Gartner.com[/td][td]Weforum.org[/td][/tr]
[tr][td]

5​

[/td][td]Gettyimages.com[/td][td]Wellsfargo.com[/td][td]Fujitsu.com[/td][td]Kompass.com[/td][/tr]
[tr][td]

6​

[/td][td]Accenture.com[/td][td]Capitalone.com[/td][td]Cognizant.com[/td][td]Tradeindia.com[/td][/tr]
[tr][td]

7​

[/td][td]Cvent.com[/td][td]Americanexpress.com[/td][td]Capgemini.com[/td][td]Iso.org[/td][/tr]
[tr][td]

8​

[/td][td]Copart.com[/td][td]Hdfcbank.com[/td][td]It.toolbox.com[/td][td]Exportersindia.com[/td][/tr]
[/table]

Results

A1 houses a value of interes.

In B1 control+shift+enter, not just enter:

=INDEX(Sheet1!$A$1:$D$1,MIN(IF(Sheet1!$A$2:$D$11=A1,COLUMN(Sheet1!$A$1:$D$1)-COLUMN(Sheet1!$A$1)+1)))

Adjust to suit.