I am looking for a double VLOOKUP to search by a part number, look on a seperate spreadsheet for the same part number and return the quantity to ship on different dates....
Please see attached example.
All i am trying to get out of this is have the formula look at a part number, look through all the dates and quantities that this part is suppose to ship (yellow section on example) and return the correct quantity on the correct ship date.
Thank you for your help in advance!
Bookmarks