jbrown021286
Board Regular
- Joined
- Mar 13, 2023
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
i need to make a formula that references the dated in row 31 and when a47 matches one of the cells in row 31 it returns values from corresponding cells. for example if a47 was 2-feb b47 would need to = d42 , c47 would need to =d43 , e47 would need to =d40 and f47 would need to =d41. not sure if it makes a difference but all the cells being referenced are formula values