Results 1 to 5 of 5

Thread: How to update columns using VLookup function in Excel

  1. #1
    Join Date
    Feb 2009
    Posts
    69

    How to update columns using VLookup function in Excel

    hie....

    I want to update the columns in my Excel Workbook by using the Vlookup function. can anybody please provide me the information on how do I use this Vlookup function in Excel ?
    thanks....

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: How to update columns using VLookup function in Excel

    In Excel, the VLookup is a function that searches for the value in the left-most column of table_array and returns the value in the same row based on the index_number.

    The syntax for the VLookup function is:
    VLookup( value, table_array, index_number, not_exact_match )

    where,
    value is the value to search for in the first column of the table_array.
    table_array is two or more columns of data that is sorted in ascending order.
    index_number is the column number in table_array from which the matching value must be returned. The first column is 1.
    not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.

  3. #3
    Join Date
    Jan 2008
    Posts
    3,758

    Re: How to update columns using VLookup function in Excel

    The V in VLOOKUP stands for Vertical. I would suggest you to use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.

  4. #4
    Join Date
    May 2008
    Posts
    4,574

    Re: How to update columns using VLookup function in Excel

    The VLookup function by its self will not work for this. It takes a lookup value finds a match in one column and returns a value in x column on the same row.

    The syntax for this is as follows -
    VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

    For example,
    =VLOOKUP(1,A2:C10,2)

    Using an approximate match, searches for the value 1 in column A, finds the largest value less than or equal to 1 in column A, and then returns the value from column B in the same row.

  5. #5
    Join Date
    May 2008
    Posts
    4,348

    Re: How to update columns using VLookup function in Excel

    For using Vlookup function, first you need to create a Lookup table. Once, you create a lookup table, follow these steps to use Vlookup function -

    1. Add your new column on your original worksheet that will display the info pulled from the Lookup table.
    2. Place your cursor in the first blank cell in that column.
    3. From the Insert menu, select Function…. The Insert Function dialog will appear.
    4. In the Search for a function: text box, type “vlookup” and click Go.
    5. Highlight VLOOKUP and click OK.

Similar Threads

  1. How to get yes or no in Vlookup in Excel
    By Gurmeet in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 03:57 PM
  2. Excel - Multiple vlookup
    By mike_2011 in forum Windows Software
    Replies: 1
    Last Post: 28-07-2011, 03:40 AM
  3. Vlookup problem in Excel
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 02-01-2010, 06:28 PM
  4. Using vlookup function Please help
    By CheckMeNot in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 09:28 AM
  5. Need help for vlookup function
    By Sunny55 in forum Windows Software
    Replies: 4
    Last Post: 09-05-2009, 12:39 PM

Posting Permissions

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