How to use VLOOKUP and what is the importance of VLOOKUP in excel?
How to use VLOOKUP and what is the importance of VLOOKUP in excel?
Take a peek here: https://support.office.com/client/en...0&market=en-us
Pete
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks