Formula or code?

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.
 
W

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
 
P

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
 
M

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
 

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

Similar Threads

Formula or VB? 1
Formula or code? 2
IF? Vlookup? 2
Help with MACRO to Edit WORKDAY Formula? 2
Complex Record Selection 1
Help with macro lsit 0
VBA or Formula Needed ???? 8
Match based on a lookup and then flag 4

Top