Trouble with SEARCH, INDEX and MATCH

[Jack]

A B

1 115
2 249
3 249
4 329
5
6 29 abcde
7 29 abd
-----------------------------------------------
I like to have the value in kolom A of the row where the letter 'a' exist in
kolom B.
(For some reasons it is not possible to change koloms)
Is this possible and how do I doe that ?

Thanks.

 

[Don]

Jack,



=INDEX(A2:A100, MATCH("*a*",B2:B100,0))



Don

 

[Jack]

Thanks a lot Don !! It Works !!

I did not know that wildcards (*) could be used with MATCH.