fahadferoz
Member
HI,
In outlet wise due sheet from E3 to E83 I need to show when the memo started (month name only) for that particular outlet. This data can be found on the other Memo Tracker'17 sheet where the months are recorded horizontally from E3 to P3 Cell. In Memo Tracker'17 sheet the number in rows (for the corresponding outlets) under each month basically shows how many memos are created for the particular outlets. I need to see only the starting number's corresponding month.
The system needs to be like,
First, the UID of outlets need to match.
Second, excel should take the month title only (for example, Apr'16 / May'16) of that UID matched store considering when the memo number started.
Example:
In outlet wise due sheet, C3 cell has UID number 1 which matches with cell number D34 in Memo Tracker'17 sheet. In this case E3 cell in outlet wise due sheet will show Jun'16 (G3 cell from Memo Tracker'17 sheet) as that is when the memo started for that outlet.
Please help me solve the problem. Thanks!
In outlet wise due sheet from E3 to E83 I need to show when the memo started (month name only) for that particular outlet. This data can be found on the other Memo Tracker'17 sheet where the months are recorded horizontally from E3 to P3 Cell. In Memo Tracker'17 sheet the number in rows (for the corresponding outlets) under each month basically shows how many memos are created for the particular outlets. I need to see only the starting number's corresponding month.
The system needs to be like,
First, the UID of outlets need to match.
Second, excel should take the month title only (for example, Apr'16 / May'16) of that UID matched store considering when the memo number started.
Example:
In outlet wise due sheet, C3 cell has UID number 1 which matches with cell number D34 in Memo Tracker'17 sheet. In this case E3 cell in outlet wise due sheet will show Jun'16 (G3 cell from Memo Tracker'17 sheet) as that is when the memo started for that outlet.
Please help me solve the problem. Thanks!
Last edited: