I have an excel file that has 2 tabs. The first tab is labeled DATA and has 18,000 lines. The second tab is labeled Requests. I have a task of receiving a request for date change for a particulate part number at a particular location. I add that request to the request tab and then investigate if that date change can happen. If it can happen then I update the request tab with the new date for the part number and location. The pain is trying to find the part number and location in the massive amount of data in the DATA tab. Part numbers can be repeated for different locations. What I thougth I was looking for was a vlookup function but I think that may not do what I need. Something like this is the idea “If C2 = B10 and E2=J10 then K10=F2 and A10=K2” Any help is greatly apreciated.
Request tab
Request tab
Requestor | Date of the request | Item | Bake Date | Location | Bake date received | RV comments | Reason for no ability | Contact | Date request sent to contact | Date response received | |
Paco | 1/27/2025 | cookies | 3/31/2028 | bakery | 3/31/2028 | John | 1/28/2025 | 2/4/2025 | |||
Paco | 1/27/2025 | cake | 3/31/2028 | bakery | 3/31/2028 | Kim | 1/28/2025 | 2/4/2025 | |||
Paco | 1/27/2025 | candy | 3/31/2028 | Kitchen | 3/31/2028 | John | 1/28/2025 | 2/4/2025 | |||
DATA Tab | |||||||||||
Effective Date | Item | Brand | Experation Date | Routed | volume | bake status | Reason for no ability | COMMENTS | location | bake date received | reason for no ability |
12-May-2023 | Cookies | Homemade | 31-Dec-2018 | Y | 0 | None | | possible | Bakery | 3/31/2028 | |
12-May-2023 | Cake | Homemade | 30-Dec-2015 | Y | 0 | None | | no longer able | Kitchen | 6/5/2025 | |
12-May-2023 | Candy | Homemade | 31-Dec-2020 | Y | 0 | None | | yes | Kitchen | 3/31/2028 | |
12-May-2023 | Pie | Homemade | 16-Jan-2021 | Y | 0 | None | | yes | Bakery | 12/31/2025 | |