Advenced Excal Vlookup

Advanced Excel  Vlookup 

The VLOOKUP function searches vertically (top to bottom) the leftmost column of a table until a value that matches or exceeds the one you are looking up is found.
The elements being looked up must be unique and must be arranged or sorted in ascending order; that is, alphabetical order for text entries, and lowest-to-highest order for numeric entries.
The syntax is =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]).
An example of the formula is: VLOOKUP(E2, D2: M3,2, TRUE) The English translation is using the value found in the cell E2, look in the range of D2 to M3 row by row. If you find a value that matches or exceeds the value in E2, using that row, go over 2 columns to the right, grab the value there and bring it back.

There are two range_lookup argument options; TRUE or FALSE

Post a Comment