VLookup Function

Function Description: Vlookup stands for ‘Vertical’ lookup. This function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. Syntax: VLookup(lookup_value, table_array, column_index_number, range_lookup) in simpler terms we can also say VLookup(ItemtoFind, RangetoFind, ColumntoPickValueFrom, SortedorUnsorted) Example: A B […]