Returning a ship date from another sheet based on matching item and order number?
I am trying to find a formula to pull a ship date from another sheet if two criteria match.
Here's a representation of the data in the main sheet and in the ship date sheet:
So if both order# and part number match, the formula would insert the ship date from the other sheet.
Is this doable? I've messed around with IF, INDEX, COLLECT, JOIN, VLOOKUP but not having much luck.
Also due to the cell limit I've had to split the ship dates into two sheets (ship dates 1 & ship dates 2), but the main sheet may need to look up the data from either sheet. Is it possible to reference two sheets in one formula?
I've tried searching help and the forums - any assistance would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!