Here's the set up to the problem I'm having.
I have a column of dates and a column of truck numbers. I'm trying to use
VLOOKUP to find what truck numbers correspond to the dates. There are multiple dates and they're in the
MM/DD/YYYY format. A date will have multiple truck numbers attached to it. I've attached a picture of the data I'm wanting to use.
My question is how would I go about using VLOOKUP with the dates in column B as the search criteria? What I have so far is:
=VLOOKUP("3/24/2021", B:E, 4, 0).