Vlookup and Match
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!
|