Forum Discussion
Solved
Return a corresponding value if the date is found in dataset
Hey, the attachement picture shows my problem. I want a function to column b that calculates the last days value and adds sales from h column if the corresponding date, in A column, is in the G co...
First of all, thank you for your quick reply. You're already a livesaver. Unfortunately I (think I) can't use VLOOKUP as the "sum" column is before the "dates" column. I also have two more conditions I need to fulfill. I've attached a Picture for reference.
The conditions are these: Type 1 should be A and type 2 should be 1.
Justme123 Rather than uploading a picture, why not upload your file, or at least the relevant portion of it.That save me having to recreate the schedule 🙂 Otherwise, consider restructuring the data so that you can use VLOOKUP.
Sorry for bothering but thank you, I got it now!
I should have posted an example file, sorry for that.
Have a great week!