Hi guys.
I need to match reference numbers with dates. Basically:
We have a Main spreadsheet with a table with few columns.
A is reference numbers and B is delivery dates.
We also have another tab called UPS which is data with UPS deliveries.
For example references in this UPS tab are in D column and dates are in J.
So what I need, is for B cell in Main sheet to take that reference number from cell A in the same row, look for it in UPS tab in D column and if found, return date from J column in the same row >> to B cell in Main spreadsheet.
Of course I will need that to work in every cell in the column. I mean I will be just putting reference numbers in Main spreadsheet in column A and getting dates returned in column B same row (if the reference is found on UPS tab as well).
Could anyone help me with that?
That is something that would help me a lot with my work.
Thank You,
Matt.
Bookmarks