Formula or code?

  • Thread starter Thread starter WYMMIY
  • Start date Start date
W

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.
 
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
 
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
 
EC Level Employee Name Line manager Name
Click to expand...

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
 
Back
Top