I attached a file, in hope that you will understand my need. I tried using Vlookup, but as you know, vlookup only finds first value. And my Excel knowledge is very limited.
Basically, I need a formula to take the information from Database sheet (source) and place them in the CAR sheet, matching the date and the CAR name. I need this because i have a bigger number of cars to which i need to create a Daily activity sheet for vehicles.And if I could automatically import the information it would save me tons on time.
Hope you will take some time to check the attachement. Many Thanks !
Reply With Quote