Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup & Dget (Excel97)

    I think that you need to post your Vlookup formula and Dget formula for anyone to be able to help you.
    Also I assume you have tested that the Vlookup is giving you the results that you expect?

    Peter

  2. #2
    New Lounger
    Join Date
    Aug 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vlookup & Dget (Excel97)

    I am trying to use vlookup to gather the info needed for part of my Dget formula however; when I insert the value returned into my Dget formula the formula does not recognize the value (I end up with either #NA or #VALUE). If I type the value into the Dget formula it is just fine so the formula is written correctly. Is there a way to make this work or alternatively is there a way to write a macro that will piece together a range name (from data in two different cells) so that I can select and copy the approriate table to a fixed range. THANKS
    formula in Cell A27 (to return name of table range)
    =D8&G3
    Formula in Cell B27 (to return square footage value which may not be exactly a number listed in the table)
    =vlookup(C27,A27,1)
    Formula in Cell B28) (to return value based on square footage and other elements)
    =dget(A27,"Stone on Block",B26:B27)

    each formula works if the table range name is typed rather than using the A27 cell reference - A27 displays the correct range name

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup & Dget (Excel97)

    I think that you need to use the "Indirect" Function in your Vlookup

    =vlookup(C27,indirect(A27),1)

    I have not used Dget but it is probably the same problem

    HTH


    Peter

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup & Dget (Excel97)

    THANKS that works like a charm! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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