G
Guest
Guest
is there a formula that will address the following issue:
i have a separate tab for each month (jan!, feb!...) of the year - in one of the columns i look up values from the prior month (tab)
i make a copy of the feb! sheet and name it mar!. the lookup value is still linked to jan! (the prior month for the feb! sheet).
is there a formula whereby i don't have to change the vlookup formula from jan! to feb!?
i have a separate tab for each month (jan!, feb!...) of the year - in one of the columns i look up values from the prior month (tab)
i make a copy of the feb! sheet and name it mar!. the lookup value is still linked to jan! (the prior month for the feb! sheet).
is there a formula whereby i don't have to change the vlookup formula from jan! to feb!?