+ Reply to Thread
Results 1 to 3 of 3

VLookup - creating a variable Sheet reference?

  1. #1
    Registered User
    Join Date
    06-26-2007
    Posts
    1

    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:
    VLOOKUP($A1,'January'!$A:$P,B$10,FALSE)


    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.


    Thanks,
    Reid

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


    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
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,649
    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)

Bookmarks

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