T
tomandrobyn
I have a report (PD05.xls) that has 5 sheets (Week 1 to Week 5) with th
date on L1 of each sheet, M1 says week 1, week 2, etc. to match th
sheet's tab.
Is it possible to do a lookup from a different spreadsheet (PD0
Recap.xls) with the date entered in A1 to look for a particular date
and have it show which week #?
For example, say for most stores sept 25 is Week 1, but some run o
different periods so they might be on week 3. If I could get a cell t
display what week they're on, I could do an IF to automatically link t
the proper sheet (instead of finding out what week they are and manuall
doing a replace all for Week 1 to Week 3).
Thanks in advance guys
date on L1 of each sheet, M1 says week 1, week 2, etc. to match th
sheet's tab.
Is it possible to do a lookup from a different spreadsheet (PD0
Recap.xls) with the date entered in A1 to look for a particular date
and have it show which week #?
For example, say for most stores sept 25 is Week 1, but some run o
different periods so they might be on week 3. If I could get a cell t
display what week they're on, I could do an IF to automatically link t
the proper sheet (instead of finding out what week they are and manuall
doing a replace all for Week 1 to Week 3).
Thanks in advance guys