index | Excel Help
Your Programming and Traning Professionals

index

Home » index
Tips and Tricks using VLOOKUP

Tips and Tricks using VLOOKUP

The VLOOKUP function is one of the staple functions that Microsoft Excel users rely upon for finding values in a table. With the VLOOKUP function, a value can be looked up in the leftmost column and a related value can be returned from another column. The Syntax for VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup […]

Read More
INDEX, MATCH & VLOOKUP

INDEX, MATCH & VLOOKUP

Excel users frequently have a need to lookup data in one spreadsheet and use it in another. To make this job easier, Excel offers built in functions for finding information: INDEX, MATCH, and VLOOKUP. The advantages and disadvantages of these functions are presented below. INDEX INDEX returns a value from a range or an array […]

Read More