Find the cell content

[Elton Law]

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

 

[Pete_UK]

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

 

[Elton Law]

OOh Sorry. I describe wrongly.
Should be

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

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

 

[Elton Law]

Hi Pete ...

Yes yes .. that works
Field should be A11 ...
Anyway, yours works. Thanks indeed.

=MATCH("*kammi*",A11,0)

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Hi Pete ...

Yes yes .. that works
Field should be A11 ...
Anyway, yours works. Thanks indeed.

=MATCH("*kammi*",A11,0)







- Show quoted text -