+ Reply to Thread
Results 1 to 3 of 3

Use of VLOOKUP

  1. #1
    Registered User
    Join Date
    06-01-2018
    Location
    India
    MS-Off Ver
    Window 7
    Posts
    1

    Use of VLOOKUP

    How to use VLOOKUP and what is the importance of VLOOKUP in excel?

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Use of VLOOKUP

    Take a peek here: https://support.office.com/client/en...0&market=en-us

    Pete

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Use of VLOOKUP

    Hello and welcome to the forum.

    Quite the general question but I'll give it a go.

    VLOOKUP is used to find a match in a list and return the value of the cell in the same row but a different column.

    Let's say for example that you have two columns, column A is Name and column B is Age, and you want to find the age of Mark Smith.

    Assuming that Mark Smith is in column A and his age is in column B, you can use a formula like this
    =VLOOKUP("Mark Smith",A:B,2,FALSE)
    to return his age.

    If Mark Smith was found in A15, the value of B15 is what the formula will return.

+ 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. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  2. Replies: 3
    Last Post: 12-04-2014, 01:27 PM
  3. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  4. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  5. [SOLVED] Vlookup is not working and giving =vlookup(B2,$T$2:$U$135,2,false) this kind of values.
    By yogeshsharma1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2013, 04:08 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Replies: 5
    Last Post: 07-29-2009, 07:53 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