[QUOTE=vlady;2765999]so there would be two results the value and the column where that value is...
here,s a sample of getting the column title : got it from tiger--
returns the column title...
=IFERROR(INDEX($A$1:$K$1,,SMALL(IF(OFFSET($B$1:$K$1,MATCH($B$14,$A$2:$A$9,0),)="PASS",COLUMN($B$1:$K$1)),COUNTA($B$14:B14))),"")

Thanks, but as a newbie to excel fomulas the formula is a bit of a minefield. What is the small wording ?