+ Reply to Thread
Results 1 to 7 of 7

vlookup

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    vlookup

    VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

    look up value is iv1

    table array is A1 TO Z500

    How do i get it to look up IV1 in column C and return value in column A?

    any help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,287
    Here's an example workbook
    http://www.freewebs.com/davesexcel/V...20Example2.xls

  3. #3
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    thanks but not quite what i wanted

    thats fine but how do i change it from using the first column in the data range. I need it to use column C.third column

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,287
    Quote Originally Posted by khalid79m
    thats fine but how do i change it from using the first column in the data range. I need it to use column C.third column
    Hi,
    Vlookup does not work backwards, you will require index match....
    http://www.contextures.com/IndexMatchSample.zip
    at
    http://www.contextures.com/xlFunctions03.html

  5. #5
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    hi

    I dont follow, can anyone give me any guidance, i havent used these functions before.

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    http://www.mrexcel.com/tip021.shtml
    gives a good explanation of using index match

  7. #7
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    thanks

    i finally cracked it.. index match.. really appreciate your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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