2012/2/23 Kris
> Hi
>
> In C16 and copied down,
>
> =INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0))
>
> Kris
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need
Hi
In C16 and copied down,
=INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
