Find the cell content

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
 
P

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
 
E

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
 
E

Elton Law

Hi Pete ...

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

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

Pete_UK

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top