Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: VLOOKUP

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Sam Marx
    Posts
    90
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have experience using VLOOKUP in Lotus and Symphony. Now I want to use a VLOOKUP in Excel but I'm running into a problem. To isolate the problem I set up a very simple basic VLOOKUP array and VLOOKUP column and still am getting incorrect readings. It is a very very simple array and I can't figure out the problem. As I said I'm new to Excel.
    I believe emailing the array to anyone interested in finding the problem would be the simplest (only) way to figure it out. Let me know your email address and I'll send it.
    Thanks,
    Sam Marx

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ~Anne Troy

  3. #3
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-09 09:36, sm2200 wrote:
    I have experience using VLOOKUP in Lotus and Symphony. Now I want to use a VLOOKUP in Excel but I'm running into a problem. To isolate the problem I set up a very simple basic VLOOKUP array and VLOOKUP column and still am getting incorrect readings. It is a very very simple array and I can't figure out the problem. As I said I'm new to Excel.
    I believe emailing the array to anyone interested in finding the problem would be the simplest (only) way to figure it out. Let me know your email address and I'll send it.
    Thanks,
    Sam Marx
    Sam, go ahead and e-mail the spreadsheet. For an explanation of Excel VLOOKUP you might want to look at:

    http://ca.geocities.com/b_davidso/We...kup.html#VLOOK

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,613
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-09 09:36, sm2200 wrote:
    I have experience using VLOOKUP in Lotus and Symphony. Now I want to use a VLOOKUP in Excel but I'm running into a problem. To isolate the problem I set up a very simple basic VLOOKUP array and VLOOKUP column and still am getting incorrect readings. It is a very very simple array and I can't figure out the problem. As I said I'm new to Excel.
    I believe emailing the array to anyone interested in finding the problem would be the simplest (only) way to figure it out. Let me know your email address and I'll send it.
    Thanks,
    Sam Marx
    Sam,

    Consider the following sample

    {1,2.3;2,2.4;3,8.7;5,2.1;6,3.5}

    in A2:B6. That is, A2 houses 1, B2 2.3, A3 2, etc.

    Suppose you want to retrieve the value associated with 4 from the above "table". The range A2:B6 is as it were a 2-column table.

    Put this 4, which is a lookup value, in C2.

    In D2 enter:

    [1]

    =VLOOKUP(C2,$A$2:$B$6,2)

    In E2 enter:

    [2]

    =VLOOKUP(C2,$A$2:$B$6,2,0)

    In [1], VLOOKUP executes an approximate match. That is, it looks in A2:A6 for a value that is (a) closest or (b)equal to 4.
    This use of VLOOKUP requires that the "table" is sorted in ascending (or in some cases, in descending) order.

    In [2], VLOOKUP is asked to execute an exact match between the lookup value in C2 and the values in A2:A6. The flag or match-type 0 signals the demand for an exact match. FALSE instead of 0 does the same. We could also have added 1 (or TRUE) in [1] to signal that we want a closest/approximate match. Omitting that boils down to the same.

    The synntax of this function is thus:

    VLOOKUP(lookup-value,lookup-table,find-column,match-type)

    where match-type [0,1] or [FALSE,TRUE] is optional; find-column is specified by a number. In our lookup-table which is A2:B6, A2:A6 is column 1 and B2:B6 is column 2.

    Hope this helps.

    Aladin

Some videos you may like

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
  •