Vlookup and Match

ExcelVlookup · #1 06-19-2015, 07:10 AM

Hello,

I have two sheets and I want to look up information in sheet two and paste it than automatically if it fullfills the conditions in sheet one.
The conditions are that the name is the same and the date. So for example
look up the name "MAXIMUS - TOT RETURN IND" and the date "08.07.1997" in sheet 2 and then paste the stock price in the corresponding cell in sheet 1.

I attached the file. It would be very nice if someone could help me.
Thank you very much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup or match	uhlersa	Excel	2	12-04-2012 12:35 AM
Match Index with sumproduct/vlookup	angie.chang	Excel	1	06-18-2012 08:47 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM
Vlookup, offset, match & countif	jujuwillis	Excel	2	10-15-2011 11:06 AM
Vlookup and If conditions together along with match formulas	david_benjamin	Excel	2	04-11-2011 11:30 AM