Hello friends,
I come to you in a time of need. I am attempting to provide an availability date(column G) for any given customer order(column B). I have my production schedule on the right, and was
hoping for some help on the formula in (column G). I have gathered from other posts that an INDEX MATCH is probably the correct way to go, but being a VLOOKUP user I can't quite get
one to work. The gist would be if F2 is less than or equal to K2, spit out I2. If not spit out the date in column I that is on the same row as the value in column K that is greater than F2. Hopefully that makes sense.
Thank you in advance for any help. This is such a helpful forum
I come to you in a time of need. I am attempting to provide an availability date(column G) for any given customer order(column B). I have my production schedule on the right, and was
hoping for some help on the formula in (column G). I have gathered from other posts that an INDEX MATCH is probably the correct way to go, but being a VLOOKUP user I can't quite get
one to work. The gist would be if F2 is less than or equal to K2, spit out I2. If not spit out the date in column I that is on the same row as the value in column K that is greater than F2. Hopefully that makes sense.
Thank you in advance for any help. This is such a helpful forum