sync data with vlookup? between two sheets.

nicholag

New Member
Joined
Oct 16, 2020
Messages
2
Office Version
  1. 365
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



RequestorDate of the requestItemBake DateLocationBake date receivedRV commentsReason for no abilityContactDate request sent to contactDate response received
Paco1/27/2025cookies
3/31/2028
bakery
3/31/2028
John
1/28/2025
2/4/2025
Paco1/27/2025cake
3/31/2028
bakery
3/31/2028
Kim
1/28/2025
2/4/2025
Paco1/27/2025candy
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 abilityCOMMENTS
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
 

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top