J
jesseb
Hi,
I am currently running the following function, which looks up the valu
on a table array on a worksheet labelled 2004:
=VLOOKUP(Info!A22,'2004'!A5:I16,9)
However, I have many worksheets, all labelled according to their year
and new worksheets that will be created and also labelled with thei
according year. What I am trying to do is to replace the stati
sheetname with a function that returns the current year, allowing me t
lookup the correct worksheet according to the current year. I've bee
trying to replace 2004 with the function YEAR(NOW()) but keep gettin
#N/A.
Am I not entering it correctly, or can this not be done? If so, wha
alternative can I go with that will help me accomplish what I am tryin
to do?
Your help is much appreciated!
Jess
I am currently running the following function, which looks up the valu
on a table array on a worksheet labelled 2004:
=VLOOKUP(Info!A22,'2004'!A5:I16,9)
However, I have many worksheets, all labelled according to their year
and new worksheets that will be created and also labelled with thei
according year. What I am trying to do is to replace the stati
sheetname with a function that returns the current year, allowing me t
lookup the correct worksheet according to the current year. I've bee
trying to replace 2004 with the function YEAR(NOW()) but keep gettin
#N/A.
Am I not entering it correctly, or can this not be done? If so, wha
alternative can I go with that will help me accomplish what I am tryin
to do?
Your help is much appreciated!
Jess