Results 1 to 4 of 4

Thread: Excel : vlookup multiple values

  1. #1
    Join Date
    Mar 2009
    Posts
    60

    Excel : vlookup multiple values

    I have created excel file in excel 2007 with two columns 1]name 2]data and three row with 1]Emp no 2]Emp name 3] Emp age. Now i am looking for feature or tool in excel which search a value and replace the same value in row form selected column.

  2. #2
    Join Date
    Dec 2008
    Posts
    371

    Re: Excel : vlookup multiple values

    Are you looking to find 2nd and 3rd column data or are you wanting to look up the combination of name based on that combination, find the result from another row ?

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Excel : vlookup multiple values

    You use the VLOOKUP function to search multiple value in the first column of a list and return a value in the same row from another column in the list. Note that the VLOOKUP function is designed to return only the corresponding value of the first instance of a lookup value.

    For example, if I type "Emp 9" in cell A9 (column 10 and I type the following VLOOKUP formula in B9 (Row 9 and 2nd column) :

    =VLOOKUP(A9,A1:B7,2,FALSE)

    The VLOOKUP function in cell B9 finds the first occurrence of the name "Emp 9", and returns the corresponding value in the same row of the second column.

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

    Re: Excel : vlookup multiple values

    VLookup is a very powerful tool for finding multiples values in a table. The Vlookup search the value given formula and gives the exact match of that value in specified column or row and remove possible error values.

Similar Threads

  1. How to get multiple values of Vlookup in Single Cell
    By Henriksen in forum MS Office Support
    Replies: 4
    Last Post: 25-02-2012, 11:02 AM
  2. Replies: 3
    Last Post: 21-01-2012, 01:43 AM
  3. Excel - Multiple vlookup
    By mike_2011 in forum Windows Software
    Replies: 1
    Last Post: 28-07-2011, 03:40 AM
  4. Lookup multiple values in excel
    By Alatar1313 in forum Windows Software
    Replies: 1
    Last Post: 09-12-2009, 02:49 AM
  5. Replies: 5
    Last Post: 27-10-2009, 12:40 AM

Tags for this Thread

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
  •  
Page generated in 1,656,867,888.31425 seconds with 16 queries