Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » V lookups
Resolved · Low Priority · Version 2003
Joshua has attended:
Excel Intermediate course
Excel Advanced course
What is purpose of a V lookup?
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
|
Excel tip:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
We'll call during UK business hours
Server loaded in 0.08 secs.