Auto-populating data from one sheet to another

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Hi, I am having a really hard time here with this.

What I have is data on sheet 1 being an employees number,
and a score they got on a training quiz. (Columns A and
B).

On sheet 2 I have there Name, employee number, and another
column to show what their score is. (Column A, B and C - C
is blank for the meantime)

What I need it to do is show the score on sheet 2 b/c that
is where their name AND employee number is.

How do I take the data from sheet one and have it auto
populate into sheet two to where it matches up with their
name? I dont want to do this manually as I have over 500
employees.

Thanks in advance.

S
 
Try this...........

I assume you have headers on sheet 2 so in C2 put this formula

=vlookup(A2,Sheet1!A:B,2,false)

Then copy it down column C..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top