Ank
Ank

Reputation: 6270

using vlookup with excel

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

Answers (2)

barry houdini
barry houdini

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

RichardTheKiwi
RichardTheKiwi

Reputation: 107826

In Sheet2, C2: =VLOOKUP(A2,Sheet1!A:B,2,FALSE) and copy down

Upvotes: 1

Related Questions