VLOOKUP

[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!?

 

[lenze]

There may be a way, but it's fairly easy to change them all at once. Just select all the cells with the Lookup formulas and use Find and Replace
This message was edited by lenze on 2002-03-14 09:35