+ Reply to Thread
Results 1 to 6 of 6

Is V-Lookup suitable

  1. #1
    Registered User
    Join Date
    07-21-2008
    Location
    New Zealand
    Posts
    35

    Is V-Lookup suitable

    I just can't get it to work. It always gives N/A. The help file says:

    "Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string"

    Ok, so a column containing values that will be used to reference other columns...

    "Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List"

    Array?

    (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.)

    But whether the array could also just be categorical variables? Because in my dataset one variable is not the 'function' of the other in a mathematical sense.

    I have two columns B and C that contain data to be referenced by A. Essentially:

    A is related to B
    B is related to C

    I want the formula to lookup each value in A, find a match in B, then give me the value that appears beside B in C. Is this possible with V-Lookup, or should I be using something else?

    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    confused, it is better that you give a sample file

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day,

    If you are unable to post your information online have I look at a upload file I posted with a number of examples within that file.

    http://www.excelforum.com/excel-gene...m-vlookup.html

    Look at file example in post number 8

    HTH
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  4. #4
    Registered User
    Join Date
    07-21-2008
    Location
    New Zealand
    Posts
    35
    thanks for your reply. i tried using the examples you gave but it produced #VALUE

    i have attached a spreadsheet with the data for you to take a look at.

    cheers
    Attached Files Attached Files

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    You're Lookup values are Numbers, and the table contains Text so try

    =VLOOKUP((A2&""),$B$2:$C$75,2,FALSE)
    See link for more

    http://www.contextures.com/xlFunctions02.html#Trouble

    VBA Noob
    Last edited by VBA Noob; 09-07-2008 at 04:59 PM.
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  6. #6
    Registered User
    Join Date
    07-21-2008
    Location
    New Zealand
    Posts
    35
    Good man! That worked perfectly!
    Thanks for the link too
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lookup when lookup value is in middle of table
    By Brokovich in forum Excel General
    Replies: 8
    Last Post: 05-28-2016, 11:32 AM
  2. How to add multiple items using lookup?
    By Weasel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2008, 06:34 PM
  3. Matrix / multiple lookup / iteration challenge
    By MarkFranklin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-19-2008, 06:45 AM
  4. Cell lookup and output issue...
    By yellephant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2007, 11:27 AM
  5. VLOOKUP - varying the LOOKUP
    By adscrim in forum Excel General
    Replies: 3
    Last Post: 03-20-2007, 09:23 AM

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