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 .
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.
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.
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
JohnTopley......You mean to say Option A is correct. am i right ?
Option C: finds value related to Search (LOOKUP) value.
Try it.
Why option B is not ? plz expain
... depends on what YOU mean by the above.Checks whether text is the same in one cell as in the next
I have given a full explanation so TRY it as this is the best way to learn.
Hi ift,
I was hoping you read the statement in the link of:
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".VLOOKUP retrieves information from a database/list based on a supplied instance of the unique identifier.
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?
@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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks