Hello, I'm wondering if you can help me.
I'm a farmer working on a planting schedule.
I have a bunch of harvest dates next to a bunch of vegetables on a sheet named "Harvest Sheet"
Column A: Vegetable Name
Column B: Start Harvest Date
Column C: Last Harvest Date
On another sheet, entitled "CSA Plan Sheet" I have
Column A: Vegetable Name
Column B: Unit of Vegetable
Cell E2: date of Vegetable pickup
I would like to set up a system on "CSA Plan Sheet" where the number "1" is returned on column B if and only if the date of the vegetable pickup (E2 on CSA Plan Sheet) is in between (or equal to) the Start Harvest Date (Column B) and the Last Harvest Date (Column C) of the corresponding vegetable on the "Harvest Sheet". I can't get Index Match or VLookup to work, maybe because there are multiple vegetables with the same name under different dates.
For instance, on "Harvest Sheet" it'll be like
Vegetable Start Harvest End Harvest
Arugula 5/20 6/1
Arugula 7/20 8/1
I need the formula to look up all of the vegetables in the same name on the Harvest Sheet, and if just one matches the criteria of the "Vegetable pickup" date being inbetween the STart Harvest and End Harvest dates, to return a "1". I hope someone can help me!
Thank you
I'm a farmer working on a planting schedule.
I have a bunch of harvest dates next to a bunch of vegetables on a sheet named "Harvest Sheet"
Column A: Vegetable Name
Column B: Start Harvest Date
Column C: Last Harvest Date
On another sheet, entitled "CSA Plan Sheet" I have
Column A: Vegetable Name
Column B: Unit of Vegetable
Cell E2: date of Vegetable pickup
I would like to set up a system on "CSA Plan Sheet" where the number "1" is returned on column B if and only if the date of the vegetable pickup (E2 on CSA Plan Sheet) is in between (or equal to) the Start Harvest Date (Column B) and the Last Harvest Date (Column C) of the corresponding vegetable on the "Harvest Sheet". I can't get Index Match or VLookup to work, maybe because there are multiple vegetables with the same name under different dates.
For instance, on "Harvest Sheet" it'll be like
Vegetable Start Harvest End Harvest
Arugula 5/20 6/1
Arugula 7/20 8/1
I need the formula to look up all of the vegetables in the same name on the Harvest Sheet, and if just one matches the criteria of the "Vegetable pickup" date being inbetween the STart Harvest and End Harvest dates, to return a "1". I hope someone can help me!
Thank you