Find the cell content

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
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
 
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
Click to expand...
 
Hi Pete ...

Yes yes .. that works
Field should be A1:D1 ...
Anyway, yours works. Thanks indeed.

=MATCH("*kammi*",A1:D1,0)
 
You're welcome - thanks for feeding back.

Pete

Hi Pete ...

Yes yes .. that works
Field should be A1:D1 ...
Anyway, yours works. Thanks indeed.

=MATCH("*kammi*",A1:D1,0)







- Show quoted text -
Click to expand...
 
Back
Top