I'm not sure why you expect a 5 in A5 when Kammi is in A3 (was that a
typo?), but if you put this in A5:

=MATCH("*Kammi*",A1:A4,0)

then it will return 3. Note the use of asterisks, which are wildcard
characters.

Hope this helps.

Pete

On Dec 19, 3:28*pm, Elton Law
wrote:
Dear expert,

Say informationlike this ...
Cell A1
Leo, Patrick, Dion, Carmen
Cell A2
25,78,98,27
Call A3
Jenny, Yvonne, Kammi, Peter
Cell A4
Chrain, Ricky, Terence, Jamie

Can I use a function to search Kammi and return the column address in Cell
A5 please?
In this case, Kammi in A3. Cell A5 should show 5 as answer.
Can you advise how to do it please? Thanks indeed