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,
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Look up value in a table, Return corresponding header
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
It should not be that difficult to create a scaled-down sample and post it here along with the desired results.
Sheet1
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.
Sheet1
| Row\Col | A | B | C | D |
1 | Business Services | Financial Services | Information Technology | International Business |
2 | Eventbrite.com | Paypal.com | Zdnet.com | Alibaba.com |
3 | Webex.com | Https://www.chase.com/ | Dice.com | Bbs.fobshanghai.com |
4 | Freelancer.com | Bankofamerica.com | Gartner.com | Weforum.org |
5 | Gettyimages.com | Wellsfargo.com | Fujitsu.com | Kompass.com |
6 | Accenture.com | Capitalone.com | Cognizant.com | Tradeindia.com |
7 | Cvent.com | Americanexpress.com | Capgemini.com | Iso.org |
8 | Copart.com | Hdfcbank.com | It.toolbox.com | Exportersindia.com |
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.
Upvote
0
