Hello,
I'm looking for a formula that will achieve the following.
Any help would be greatly appreciated.
Sheet1
Sheet2
On Sheet2, I would put the formula in C2, and copy throughout the sheet.
If cells B&A (280002443601) on Sheet2 is listed in column "X" on Sheet1 and the date in cell C1 (1/22/2024) on Sheet2 is >= to the date in column AB on Sheet1 and <= to date in column AC on Sheet 1, then return the value showing in column AE on Sheet1 for that row.
In the data listed above, I would want the below information to show.
For row 3 (3602), it would return 1,427 from 1/22/24 - 2/24/24.
For row 4 (3603), it would return 1,427 from 1/22/24 - 2/26/24.
Is this possible?
If not, and you know a better option to pull that data, please let me know.
Thanks!
I'm looking for a formula that will achieve the following.
Any help would be greatly appreciated.
Sheet1
Sheet2
On Sheet2, I would put the formula in C2, and copy throughout the sheet.
If cells B&A (280002443601) on Sheet2 is listed in column "X" on Sheet1 and the date in cell C1 (1/22/2024) on Sheet2 is >= to the date in column AB on Sheet1 and <= to date in column AC on Sheet 1, then return the value showing in column AE on Sheet1 for that row.
In the data listed above, I would want the below information to show.
For row 3 (3602), it would return 1,427 from 1/22/24 - 2/24/24.
For row 4 (3603), it would return 1,427 from 1/22/24 - 2/26/24.
Is this possible?
If not, and you know a better option to pull that data, please let me know.
Thanks!