Hi everyone,
I have a workbook with 2 worksheets. The first worksheet has dates in column A, company name in column B
The second worksheet is called "Reference" and it has most recent order date in column A and company name in column B
I'm trying to match the date in sheet 1 to the closest date in sheet 2 for each company and return the date they ordered in column C of woorksheet 1
(The same company can appear in both worksheets multipe times)
Thank you in advance.
I have a workbook with 2 worksheets. The first worksheet has dates in column A, company name in column B
The second worksheet is called "Reference" and it has most recent order date in column A and company name in column B
I'm trying to match the date in sheet 1 to the closest date in sheet 2 for each company and return the date they ordered in column C of woorksheet 1
(The same company can appear in both worksheets multipe times)
(Sheet 1) | A | B | C (a funktion that return a value from "Reference") |
1 | 15.02.2021 | Company 1 | |
2 | 29.01.2021 | Company 1 | |
3 | 01.04.2021 | Company 1 | |
4 | 03.04.2021 | Company 2 |
(Reference) | A | B |
1 | 15.02.2021 | Company 1 |
2 | 01.02.2021 | Company 1 |
3 | 01.02.2021 | Company 2 |
4 | 01.03.2021 | Company 1 |
Thank you in advance.