Lookup Based On Column Header

[Kenshin]

Heloo glad to be back and need help, please see my attaching file

thank you ninjas

 

[Nebu]

Hi:

May be this?

Thanks

 

[Kenshin]

No it's different, it was not as I expected, but anyway thanks

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Kenshin]

Thanks Narayan it's okay now

 

[bosco_yip]

Or try this formula solution without helper

In C13, copied down :

=INDEX($A$2:$F$10,ROW()-MATCH("zz",INDEX(A:A,1):A13)+1,MATCH(LOOKUP("zz",A$12:A13),$A$1:$F$1,0))&""

Regards
Bosco

 

[Kenshin]

Now that's perfect, thanks Bosco and Narayan, you're best ninjas