Formula or code?

[WYMMIY]

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.

 

[Paul Robinson]

Hi
Absolutely no idea what you want.
regards
Paul

 

[WYMMIY]

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

 

[Paul Robinson]

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

 

[Martin Brown]

EC Level Employee Name Line manager Name

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