Re: Storing Formulas to Use
- From: "vezerid" <vezerid@xxxxxxx>
- Date: 2 Dec 2005 08:29:16 -0800
You need the INDIRECT() function, which creates dynamic addresses.
Assuming that you have your year number in a separate cell (Say K1),
and that all your worksheets have the same format, i.e. "YEARNO(space)
information", you will need the following for your VLOOKUP():
VLOOKUP(A4, INDIRECT("'" & K1 & " information'!$A$4:$L$97"), 12, FALSE)
HTH
Kostis Vezerides
.
- Prev by Date: Re: nested if function
- Next by Date: RE: Filling Text from Another File
- Previous by thread: Help with Offset/Lookup
- Next by thread: Re: Storing Formulas to Use
- Index(es):
