Reputation: 6270
I have a excel sheet tab with following values
Class Date
A 07/07/2000
B 08/07/2012
C 09/10/2011
I have a second tab with the following values
Class Student Date
A 1
A 2
B 3
B 1
C 1
I would like to add the date from sheet1 to sheet2. I know I can use VLOOKUP
but can't figure out how ! :-(
Upvotes: 0
Views: 448
Reputation: 46451
Assuming the first sheet is Sheet1 with Class in column A and Date in column B then try this formula in C2 of your second sheet
=VLOOKUP(A2,Sheet1!A$2:B$10,2,0)
copy that down to C6
Upvotes: 3
Reputation: 107826
In Sheet2, C2: =VLOOKUP(A2,Sheet1!A:B,2,FALSE)
and copy down
Upvotes: 1