I have the following formula =VLOOKUP($A$2,SpecialEvents2013!$C:$S,2,FALSE). I would like to be able to make the year (2013) variable so a user can enter another year and the formula will look at that corresponding sheet. All my sheets are SpecialEvents(then the year).
Last edited by billykiller05; 01-07-2014 at 02:00 PM.
Hi
You'll need to incorporate an INDIRECT() function. Assuming the year is in A1
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This works awesome thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks