Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
v lookups

ResolvedVersion 2003

Joshua has attended:
Excel Intermediate course
Excel Advanced course

V lookups

What is purpose of a V lookup?

RE: V lookups

Hi Joshua

A VLOOKUP is a function that allows you to find a value in a table that matches a given value.

the VLOOKUP function looks at the given value eg Product ID and then looks in the leftmost column of a table until it finds the value you specified.

When it finds this value, it returns a value located in the same row, in a specified column eg Product Name.

Its called VLOOKUP because it looks vertically down a column.

Hope this helps

Carlos

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.