Collect Join Help
I have two sheets. Sheet 1 is where requests are tracked. The user enters the date, Part Number, and Quantity they need.
Sheet 2 is where the deliveries are posted. It contains the date of the delivery, Part Number, Quantity, and location for the parts.
Back on Sheet 1, I have a column that I want to pull in the date of the delivery from sheet 2 that is greater than or equal to the requested date for the part number and quantity requested.
I then have a second column on sheet 1 where I want to pull in the location from sheet 2. Same parameters. I've viewed several of @Genevieve P. comments, but I have not been able to nail this down. Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!