Vlookup...How to add to it!
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Vlookup...How to add to it!

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Someone else started a vlookup table...I know nothin about it...how do I add things to it?

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if you go into help and look up the vlookup function (no pun intended) that should help you out. One of the arguments in the function is a range. It could be defined as in A1:E27 format, or it could be a named range, like MyDataRange. If it is the latter, you can go into the Insert-Names-Define menu and change the range, and then add your new data inside the new range.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    just add data to where the data is looked up from, then check that the formulae that refer to it still got that far in the area that it is looking.

    i.e. if the existing formula looks something like

    =VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE)
    then the cell is going to look for the value in A1 in sheet two, looking in column 1 and returning the value in column 2, in the range A1 to B20

    If you added extra data and the last row you want to now look in is 300 then you would change $B$20 to $B$300

    or start using named ranges replace all of $B$20 with a named range.


    Regards,

    Gary Hewitt-Long

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,751
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-13 12:23, CAPT.PT wrote:
    Someone else started a vlookup table...I know nothin about it...how do I add things to it?
    Post the VLOOKUP formula for a more directed response if needed.

    Aladin

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com