The VLOOKUP() function works by looking up the value that is to be present in the left most column of a table. The formula looks for a certain column offset and fetches back the corresponding matched value. This formula has provision to give exact match or approximate match through its last argument that takes TRUE or FALSE to return a value.
0
The VLOOKUP() function works by looking up the value that is to be present in the left most column of a table. The formula looks for a certain column offset and fetches back the corresponding matched value. This formula has provision to give exact match or approximate match through its last argument that takes TRUE or FALSE to return a value.