wow !!

=IF(ISNA(IF(INDEX(C$6:C$10,MATCH(C20,F$6:F$10,0),1)="","",INDEX(C$6:C$10,MATCH(C20,F$6:F$10,0),1))),"",IF(INDEX(C$6:C$10,MATCH(C20,F$6:F$10,0),1)="","",INDEX(C$6:C$10,MATCH(C20,F$6:F$10,0),1)))

theres no way in h**l i would have EVER come up with ANYTHING even close to this formula.
thank you so much for your help. this is amazing !!

+rep awarded