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 […]

Welcome to MSOffice Gurus

Hi All, We are committed to share the knowledge that we have in the vastly used package, Microsoft Office.  The following posts will contain some extensive coverage of Tips from Word, Excel & PowerPoint and to some extent VBA. So, visit regularly to enhance your knowledge and drop in your comments. If you have any […]