How to use VLookup Match function in Excel
VLookup Match located Lookup & reference category it’s important & advance function which allow to perform a matrix lookup than normal lookup
Tech Guide
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.
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
Solution of Google Play Services Has stopped message
If your Google play service has been stopped and generate error message then you need to know proper solution of Google Play Services has stopped message.
How to unlock bootloader OnePlus 5T
A easy guide to unlock bootloader OnePlus 5T with image. Root your phone or use custom recovery like CWM and TWRP recovery on OnePlus 5T.
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.
Excel DatedIF function Compare between two dates
DatedIF function is quickly get difference of days, months or years between given two dates. DatedIF is categorized as a Date/Time Function.
How to lookup images in Excel using Index Match function
If you need to lookup images in Excel then you must have to use Index Match function to quickly get the result as per your need.