Formula or code?
 

I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
Col1 Col2 Col3
Row 1 EC QWERTY POIUY
Row 2 (EC-x) ZXCVB QWERTY
RO3 EC lkjhg ZXCVB
.....
Row 4 (EC-x) rtyui QWERTY
Ro4 (EC-X) asdfg lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.

Formula or code?
 

Hi
Absolutely no idea what you want.
regards
Paul


On Feb 16, 1:51*pm, WYMMIY wrote:
I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
* * * * * * * * Col1 * * * * * * * * * *Col2 * * * * * * * * *Col3
Row 1 * EC * * * * * * *QWERTY * * * POIUY
Row 2 * (EC-x) * * * *ZXCVB * * * * *QWERTY
RO3 * * *EC * * * * * * *lkjhg * * * * * * *ZXCVB
* *.....
Row 4 * * (EC-x) * * * * *rtyui * * * * * * QWERTY
Ro4 * * * *(EC-X) * * * * asdfg * * * * * * *lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.

Formula or code?
 

OK my fault the example was a bit too abstract.


EC Level Employee Name Line manager Name

EC Tom Riddle Mitesh Mistry
Answer should be EC-1 as Tom is the
boss
EC-1 Peter Ludden Tom Riddle
Answer Should be EC-2 as Shivani is one level lower inthe organisation
than Peter
EC-2 Shivani Mistry Peter Ludden
Answer should be EC-1 as Tom is Joes
boss
EC-1 Joe Blogs Tom Riddle

EC-1 John Tom Riddle
So i am checking is Peter has been identified as having a EC level or
not as he is EC-1 the answer is EC-2
EC-2 Rupert Peter Ludden

EC-3 Chaya Rupert




On Feb 16, 3:22*pm, Paul Robinson
wrote:
Hi
Absolutely no idea what you want.
regards
Paul

On Feb 16, 1:51*pm, WYMMIY wrote:



I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
* * * * * * * * Col1 * * * * * * * * * *Col2 * * * * * * * * *Col3
Row 1 * EC * * * * * * *QWERTY * * * POIUY
Row 2 * (EC-x) * * * *ZXCVB * * * * *QWERTY
RO3 * * *EC * * * * * * *lkjhg * * * * * * *ZXCVB
* *.....
Row 4 * * (EC-x) * * * * *rtyui * * * * * * QWERTY
Ro4 * * * *(EC-X) * * * * asdfg * * * * * * *lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.- Hide quoted text -

- Show quoted text -

Formula or code?
 

Hi
Still no idea how you might be drawing your conclusions from the
information you have given. Remember, we can ONLY see the information
you have given so concluding that "Answer should be EC-1 as Tom is
the boss" after one line of data is somewhat mysterious.
regards
Paul


On Feb 17, 9:57*am, WYMMIY wrote:
OK my fault the example was a bit too abstract.

EC Level * * * * * * *Employee Name * * Line manager Name

EC * * * * * * * *Tom Riddle * * * * * * * * * *Mitesh Mistry
Answer should be EC-1 as Tom *is the
boss
EC-1 * * * * * * *Peter Ludden * * * * * * * * *Tom Riddle
Answer Should be EC-2 as Shivani is one level lower inthe organisation
than Peter
EC-2 * * * * * * * *Shivani Mistry * * *Peter Ludden
Answer should be EC-1 as Tom is Joes
boss
EC-1 * * * * * * * *Joe Blogs * * * * * * * * * Tom Riddle

EC-1 * * * * * * * * John * * * * * * * * * * * Tom Riddle
So i am checking is Peter has been identified as having a EC level or
not as he is EC-1 the answer is EC-2
EC-2 * * * * * * * * *Rupert * * * * * * * * * * Peter Ludden

EC-3 * * * * * * * * *Chaya * * * * * * * * * * * Rupert

On Feb 16, 3:22*pm, Paul Robinson
wrote:



Hi
Absolutely no idea what you want.
regards
Paul

On Feb 16, 1:51*pm, WYMMIY wrote:

I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
* * * * * * * * Col1 * * * * * * * * * *Col2 * * * * * * * * *Col3
Row 1 * EC * * * * * * *QWERTY * * * POIUY
Row 2 * (EC-x) * * * *ZXCVB * * * * *QWERTY
RO3 * * *EC * * * * * * *lkjhg * * * * * * *ZXCVB
* *.....
Row 4 * * (EC-x) * * * * *rtyui * * * * * * QWERTY
Ro4 * * * *(EC-X) * * * * asdfg * * * * * * *lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Formula or code?
 

On 17/02/2012 10:47, Paul Robinson wrote:
EC Level Employee Name Line manager Name

EC Tom Riddle Mitesh Mistry
Answer should be EC-1 as Tom is the
boss
EC-1 Peter Ludden Tom Riddle
Answer Should be EC-2 as Shivani is one level lower inthe organisation
than Peter
EC-2 Shivani Mistry Peter Ludden
Answer should be EC-1 as Tom is Joes
boss
EC-1 Joe Blogs Tom Riddle

EC-1 John Tom Riddle
So i am checking is Peter has been identified as having a EC level or
not as he is EC-1 the answer is EC-2
EC-2 Rupert Peter Ludden

EC-3 Chaya Rupert


Assuming the names are truly unique and spelt correctly something like

=INDEX(B$3:B19,MATCH(D6,C$3:C19,0),1)+1

Ought to do it. Where the columns are

A B C D
"EC-"&B1 0 Tom Riddle Mitesh


--
Regards,
Martin Brown