Triple VLookup with Index Match function in Excel
If you have more than one criteria then you need to apply triple VLookup. You can use Index Match function for triple VLookup in worksheet.
Microsoft-Office
VLookup with Two Lookup Values using IFError function
if you need to apply more than one criteria to get result during lookup. In that situation you have to use VLookup with two lookup values.
How to insert Excel Pivot Table Calculated Field or Calculated Item
Quickly insert one or more filed in active pivot table. This guide allows you to insert Excel Pivot Table Calculated Field or Calculated Item.
How to use IFNA with VLookup function
Sometime you need to use IFNA with VLookup function together. It helps you to remove #N/A error if lookup value does not matched in the list.c
How to use the Match function in Excel
Match function allows you to quickly locate for a specified item in range of cells and then returns relative position of that item in range.
VLookup to Get Sum, Average, Count, Maximum and Minimum value from Multiple Columns
If you need to calculate the Sum, Average, Count which condition. Then apply VLookup to get Sum, Average, Count, Max and Min function.
VLookup Function in MS Excel with Appropriate Match
Search value as per given condition in table or array by VLookup Function in MS Excel with appropriate match option for searching.
Fill Handle: To Copy or Generate Series in MS Excel
After reading this guide you will be able to easily use fill handle in Microsoft Excel with its options you can easily to copy or generate the series.
How to Use Shapes Tool and Apply Effects in MS Word
Shapes Tool and Apply Effects in MS Word. With the help of this tool you can draw and free hand object of shape and also apply different effects.
How to link data between two or more workbook in Excel
This guide allows different ways to link data between two or more workbook in Excel. You can establish, remove, edit and refresh the link.