Can I insert a function within the VLOOKUP function?? please help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top