+ Reply to Thread
Results 1 to 10 of 10

VLOOKUP question

  1. #1
    Registered User
    Join Date
    05-27-2017
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    4

    VLOOKUP question

    Qus) What does the VLOOKUP function do?

    a. Looks up text that contain v

    b. Checks whether text is the same in one cell as in the next

    c. Finds related records

    d. All of above

    Correct Answer: c


    But I think option b and c both should be correct but i am not sure so please help me out .

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,533

    Re: VLOOKUP question

    Hi and welcome to the forum,

    Read more about VLookup() at:

    https://www.howtogeek.com/howto/1378...okup-in-excel/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-27-2017
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    4

    Re: VLOOKUP question

    MarvinP ......This is not a way to reply from expert side.

    Anyone else who can help me out..
    Last edited by ift38375; 05-27-2017 at 08:01 AM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,672

    Re: VLOOKUP question

    Example:

    =VLOOKUP("v",A2:F100,2,0)

    Search for "v" in range A2:A100 (VLOOKUP uses the first column of the range to MATCH)

    IF MATCH is found, then return the value from the corresponding row range B2:B100 (2 indicates the 2nd column in defined range: column F would be 6)

    the last parameter "0" (or FALSE) indicates an EXACT match is required.

    If the data in the range is sorted in ascending order ,then change to TRUE or 1 : this will return value which is less than or equal to lookup value.

    VLOOKUP only returns the FIRST value which matches.

    Hope this helps

  5. #5
    Registered User
    Join Date
    05-27-2017
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    4

    Re: VLOOKUP question

    JohnTopley......You mean to say Option A is correct. am i right ?

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,672

    Re: VLOOKUP question

    Option C: finds value related to Search (LOOKUP) value.

    Try it.

  7. #7
    Registered User
    Join Date
    05-27-2017
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    4

    Re: VLOOKUP question

    Why option B is not ? plz expain

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,672

    Re: VLOOKUP question

    Checks whether text is the same in one cell as in the next
    ... depends on what YOU mean by the above.

    I have given a full explanation so TRY it as this is the best way to learn.

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,533

    Re: VLOOKUP question

    Hi ift,

    I was hoping you read the statement in the link of:
    VLOOKUP retrieves information from a database/list based on a supplied instance of the unique identifier.
    The idea is that VLookup is used in LISTS or TABLES of data. In your option a and b above it limits it to "text".

    I think that a full article describing a function is, many times, much better than a simple sentence or two from a forum site.

    I'm sorry you think my answer was too short. Did you really read the link I provided? Did it help at all? Are you simply mad that you missed a question on a test?

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,672

    Re: VLOOKUP question

    @MarvinP: I missed the connotation of this being an exam question!

    @Ift: C is the correct answer as VLOOKUP is not restricted to TEXT or any specific value (a) and it does not check if value (text or otherwise) ) is same a value in next cell (b).
    Last edited by JohnTopley; 05-27-2017 at 09:28 AM.

+ 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. Vlookup question
    By bourny in forum Excel General
    Replies: 4
    Last Post: 07-12-2013, 03:48 AM
  2. vlookup question, i think ?
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 11:17 AM
  3. Excel 2007 : VLOOKUP question
    By budchevy in forum Excel General
    Replies: 11
    Last Post: 04-20-2011, 10:43 PM
  4. Excel 2007 : VLOOKUP Question
    By neiln01 in forum Excel General
    Replies: 2
    Last Post: 03-01-2011, 11:39 AM
  5. Vlookup Question-how do I manage the Vlookup?
    By athard in forum Excel General
    Replies: 5
    Last Post: 12-31-2009, 06:04 AM
  6. vlookup question
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2009, 07:37 PM
  7. [SOLVED] Vlookup question
    By smith_ts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-13-2008, 06:25 AM
  8. vlookup question
    By Greegan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2005, 12:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1