Return Column Header by lookup value

taradonp

New Member
Joined
May 9, 2013
Messages
1
ABCDEResult
11100C
10010D
00101E
01010D

<tbody>
</tbody>

Like in the table above. I want to lookup the value in each row and return the header name which is the most right number "1" is located.
I know that we should use the index and match but I am not sure how to find "position of the most right number 1 located"
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
<br />
Book1
ABCDEF
1ABCDEResult
211100C
310010D
400101E
501010D
Sheet1
Cell Formulas
RangeFormula
F2=LOOKUP(2,1/(A2:E2=1),$A$1:$E$1)
F3=LOOKUP(2,1/(A3:E3=1),$A$1:$E$1)
F4=LOOKUP(2,1/(A4:E4=1),$A$1:$E$1)
F5=LOOKUP(2,1/(A5:E5=1),$A$1:$E$1)
 
Upvote 0

Forum statistics

Threads
1,214,415
Messages
6,119,381
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top