006 - Excel - Vlookup Formula
find an exact match within a range of values \u200b\u200bwithout having to reorder the source table.
How many times we found ourselves having to make a comparison with unrange values.
Determine if 5 is between 0 and 10 and 'very simple, if we compare a single value, but if we have to check thousands of cells it becomes a bit' more 'complex.
In this lesson we have assigned a "type" to all our guests, by comparing the value of sales with a range.
= VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
An excellent guide provided by Microsoft
Lesson 006
0 comments:
Post a Comment