+ Reply to Thread
Results 1 to 3 of 3

VLookup - creating a variable Sheet reference?

  1. #1
    Registered User
    Join Date

    VLookup - creating a variable Sheet reference?

    On Worksheet 1 "Jan. Income", I have a very large data table that uses VLookup formulas to pull info from a 2nd worksheet "January".
    So my VLookup formula in 'Jan. Income' would read:

    All fine so far. But I need use the 'Jan. Income' worksheet as a template for 'Feb. Income' 'Mar. Income' - the tables will pull their data from new sheets 'February', 'March', etc. The Vlookup formula will be the exact same in these new tables EXCEPT that the forumula needs to reference a different sheet (not 'January): "Feb. Income" formula should read 'February'!$A:$P; "Mar. Income needs 'March'!$A:$P...

    How do I make the sheet reference in my original Vlookup formula variable so that I can change the reference worksheet at the push of a button without having to re-type all of the formulas? Ideally I would want the sheet reference in the formula linked to a cell with the word 'January' typed. Then all I would have to do is change that cell to read "Febuary", "March", etc.


  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Have you tried the Edit > Find > Replace option?

    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007
    Or have you looked at using the INDIRECT function?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1