When looking for a unique value, FALSE should be entered for the range_lookup argument. In most cases people are looking for a particular product, order, employee or customer and therefore require an exact match. The last argument of the VLOOKUP function, known as range_lookup, asks if you would like an approximate or an exact match.
0 Comments
Leave a Reply. |