# VLOOKUP question

1. ## 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

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

2. ## Re: VLOOKUP question

Hi and welcome to the forum,

https://www.howtogeek.com/howto/1378...okup-in-excel/

3. ## Re: VLOOKUP question

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

Anyone else who can help me out..

4. ## 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. ## Re: VLOOKUP question

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

6. ## Re: VLOOKUP question

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

Try it.

7. ## Re: VLOOKUP question

Why option B is not ? plz expain

8. ## 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. ## Re: VLOOKUP question

Hi ift,

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. ## 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).

There are currently 1 users browsing this thread. (0 members and 1 guests)