Re: Get Column Header from Match in a Array?
From
Mohit Raj Bhurat@21:1/5 to
All on Thu Oct 5 21:43:02 2023
I used rather simpler formula which worked for me (In google sheets tho)
=INDEX(Data,1,MIN(IF(Data=J3,COLUMN(Data))))
Data here is a named range to that the formula looks neat- Data: 'Sheet 1'!A2:G1503
J3 is the cell where I want to look up the value from
My header is in row 1, hence the second parameter in the index is 1
Equivalent Row formula is also given below
=INDEX(Data,MIN(IF(Data=J3,ROW(Data))),1)
I have my unique row identifier in column 1 hence the third parameter in the index is 1.
Hope it helps!
--
This e-mail transmission contains confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. Under no circumstances may any such information be
disclosed, copied, used or disseminated to any unauthorised person, firm, corporation or any other entity without written approval of Impact
Analytics, Inc or its subsidiaries. If you are not the intended recipient,
you are hereby notified that any disclosure, copying, distribution, or
reliance upon the contents of this e-mail is strictly prohibited. If you
have received this e-mail transmission in error, please reply to the
sender, so that Impact Analytics, Inc or its subsidiaries can arrange for proper delivery, and then please delete the message. This e-mail message including attachment/(s), if any, is believed to be free of any virus.
However, it is the responsibility of the recipient to ensure that it is
virus free and Impact Analytics, Inc or its subsidiaries will not be responsible for any loss or damage arising in any way from its use.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
From
Mohit Raj Bhurat@21:1/5 to
All on Thu Oct 5 21:44:32 2023
I used rather simpler formula which worked for me (In google sheets tho)
=INDEX(Data,1,MIN(IF(Data=J3,COLUMN(Data))))
Data here is a named range to that the formula looks neat- Data: 'Sheet 1'!A2:G1503
J3 is the cell where I want to look up the value from
My header is in row 1, hence the second parameter in the index is 1
Equivalent Row formula is also given below
=INDEX(Data,MIN(IF(Data=J3,ROW(Data))),1)
I have my unique row identifier in column 1 hence the third parameter in the index is 1.
Hope it helps!
--
This e-mail transmission contains confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. Under no circumstances may any such information be
disclosed, copied, used or disseminated to any unauthorised person, firm, corporation or any other entity without written approval of Impact
Analytics, Inc or its subsidiaries. If you are not the intended recipient,
you are hereby notified that any disclosure, copying, distribution, or
reliance upon the contents of this e-mail is strictly prohibited. If you
have received this e-mail transmission in error, please reply to the
sender, so that Impact Analytics, Inc or its subsidiaries can arrange for proper delivery, and then please delete the message. This e-mail message including attachment/(s), if any, is believed to be free of any virus.
However, it is the responsibility of the recipient to ensure that it is
virus free and Impact Analytics, Inc or its subsidiaries will not be responsible for any loss or damage arising in any way from its use.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)