Vlookup?

[Reaper65]

I have two worksheets both of them have names and dates but the values are different.

I want to compare the names and dates and if they match bring in the values from one worksheet to other.

Is best to use a vlookup for this? I'm drawing a blank this morning.



Thanks in advance for any help.
R65

 

[texasalynn]

index/match since you have two areas that need to be matched.

 

[proficient]

Something like this...

Excel Workbook
	A	B	C
1	Name	Date	Amount
2	Kamran	17-Feb-13	100
3	Adnan	18-Feb-13	250
4	Imran	19-Feb-13	400
5	Faizan	20-Feb-13	550
6	Rehan	21-Feb-13	700
7	Arsalan	22-Feb-13	850
8	Kamran	23-Feb-13	1000
9	Adnan	24-Feb-13	1150
10	Imran	25-Feb-13	1300
Sheet 1

Excel Workbook
	A	B	C
1	Name	Date	Amount
2	Kamran	17-Feb-13	100
3	Adnan	18-Feb-13	250
4	Faizan	20-Feb-13	550
5	Rehan	21-Feb-13	700
Sheet 2