Hi Experts
I want YTD No. in column B tab Sheet 2 from Sheet 3 based on the A1 Sheet 1, please share formula
Sheet 1
A1 = Apr
Sheet 2
Sheet 3
I want YTD No. in column B tab Sheet 2 from Sheet 3 based on the A1 Sheet 1, please share formula
Sheet 1
A1 = Apr
Sheet 2
Month | YTD No. |
Apr | 120 |
Apr | 120 |
Apr | 120 |
May | 0 |
Sheet 3
Jan | 31 |
Feb | 59 |
Mar | 90 |
Apr | 120 |
May | 151 |
Jun | 181 |
Jul | 212 |
Aug | 243 |
Sep | 273 |
Oct | 304 |
Nov | 334 |
Dec | 365 |