Match Header & a row value to get corresponding values

[fortune]

Please see attached file as per above (post #21) reply

Regards
Bosco

Please respond to post #25

 

[fortune]

View attachment 63365

In I2, copied to J2 and all copied down :

=IFERROR(1/(1/INDEX($B2:$G2,AGGREGATE(15,6,COLUMN($B$1:$G$1)-COLUMN($A$1)/($B$12:$G$12=AGGREGATE(14,6,$B$12:$G$12/($B$1:$G$1=I$1),1))/($B$1:$G$1=I$1),1))),"")

Regards
Bosco

NOT WORKING.........The values in I2:J9 gives WRONG results!!!

 

[fortune]

STILL NOT WORKING. SEE THE FILE ATTACHED WITH YOUR FORMULA of post #27. I am using Excel 2007

 

[bosco_yip]

Stop replied with All Caps! All Caps = Shouting.

PLEASE DON'T SHOUT! We have big ears and will hear you just the same.

Here's the rule of the forum

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Regards

 

[fortune]

my apology feel sorry

 

[p45cal]

What's more, I'm not happy that you cross posted this question at https://www.ozgrid.com/forum/forum/...header-a-row-value-to-get-corresponding-value without telling us. You knew about the cross posting issue some 5 years ago.
It seriously reduces your chances of getting help from me in future.