Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOKUP in multiple ranges in multiple sheets (2000)

    Is there a way to create a vlookup formula with reference to multiple sheets? I am having trouble explaining my question with words. Please view my attachment as an example: In my "Total" sheet, I would like to create a vlookup that, based on the name of the sheet, it (the formula) goes to that sheet to pull the data.

    Thanks in advance for your help!

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VLOOKUP in multiple ranges in multiple sheets

    You can use the INDIRECT function. For example the formula in B9 becomes:

    <code>

    =VLOOKUP($A$8,INDIRECT(A9&"!A8:B16"),2,FALSE)</code>



    You should note that the !A8:B16 part is in quotes to stop it being converted, whereas the A9 part of the formula will be converted to Chris

    Sample attached

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP in multiple ranges in multiple sheets

    Tony,

    God bless you! Perfect! Thank you very much!

    Chris

Posting Permissions

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