LOOK UP AND INSERT ON CHANGE

Hi Experts

In cell C3 on sheet "Sht 1 - Table 1" I need a formula or VBA code to look at cell C4 (numbers between 1 & 200) and based on that number look at sheet "Employees - Table 1" A2:A201 and match that number then insert into C3 the corrosponding name in that row in "Employees - Table 1" but from column B.  EG below:

SHEET "Sht 1 - Table 1"
       A            B                 C         D      E           F
1
2
3                              ROB DENNIS                BRETT GIFFORD
4                              3                                 5


SHEET "Employees - Table 1"
       A                  B
1      1          JOHN SMITH
2      2          JOHN SMITH JNR
3      3          ROB DENNIS
4      4          JOHN SMITH SNR
5      5          BRETT GIFFORD

So "ROB DENNIS" will be put into C3 based on the number in C4
and "BRETT GIFFORD" will be put into F3 based on the number in F4

and so on. I have this reocurring in different cells 100 times.
I dont know how to do this but guess it would be a change event in C4 that runs some code??

Cheers

Rob        
RobJanineAsked:
Who is Participating?
 
m4trixCommented:
my previous example was basically the same thing. Here's the same with your version:
 Book1-v2.xlsx
0
 
RobJanineAuthor Commented:
please note that on sheet "Employees - Table 1" the numbers in Column A (Employee ID numbers) may not be in order.
0
 
pritamduttCommented:
Please upload a worksheet with sample data..
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
m4trixCommented:
Not a problem at all...

I reordered the employees table a bit to show you the order doesn't matter.
Type any number that also exists in the employees table into row 4 on the first sheet, and the correct name will appear in row 3 directly above.

Let me know if I've missed something here
 EE-Example.xlsx
0
 
RobJanineAuthor Commented:
0
 
RobJanineAuthor Commented:
Thankyou....works great.....keep an eye out I have another question shortly but I think it may be quite hard.


Cheers and thanks again.

Rob
0
 
RobJanineAuthor Commented:
Thankyou
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.