Victor3139
New Member
- Joined
- Oct 14, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi forum,
First post here so appreciate any support.
I have the following data:
C3:I3 is merged, month is in 01/01/21 format, just custom display.
The formula I need is:
As you can see, the common variables are the numbers 1-5, the site, and the date.
I need a formula from C3 to G13 to return the corresponding number based on the 3 variables.
I figured it can be done with some kind of index match or sum ifs, but the merged cell is also giving me headaches.
Thank you in advance!
First post here so appreciate any support.
I have the following data:
C3:I3 is merged, month is in 01/01/21 format, just custom display.
The formula I need is:
As you can see, the common variables are the numbers 1-5, the site, and the date.
I need a formula from C3 to G13 to return the corresponding number based on the 3 variables.
I figured it can be done with some kind of index match or sum ifs, but the merged cell is also giving me headaches.
Thank you in advance!