New Entries Added Almost Daily! Click here to get on our Mailing List
Access Excel Word Windows HTML
In this tutorial you will learn how to use the VLOOKUP Function.
You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range.
=VLOOKUP( Lookup_value, Table_array, Col_index_num, Range_lookup )
Lookup_value Table_array Col_index_num Range_lookup
In this example <...>.
The result is <...>.
In a Cell you could set the Expression to
=VLOOKUP( )
Excel 202 | Excel Expert Level 4
See this FREE Tip on VLOOKUP.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips