Find the cell content
 

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

Find the cell content
 

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

Find the cell content
 

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" 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

Find the cell content
 

Hi Pete ...

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

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



"Pete_UK" wrote:

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

.

Find the cell content
 

You're welcome - thanks for feeding back.

Pete

On Dec 19, 5:34*pm, Elton Law
wrote:
Hi Pete ...

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

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



"Pete_UK" wrote:
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

.- Hide quoted text -

- Show quoted text -