Use Multiple Vlookup to Create Search Data Dump in Easy Steps | Vlookup Magic Trick | Excel In Hindi
In this video, We will learn about Use Multiple Vlookup to Create Search Data Dump in Easy Steps in a single Sheet also we will use the DropDown List and IfError formula. Let's see the steps below.
To Create Automatic Search Dump follow the below steps :
Copy the Headers in Vertical form using Paste Special Transpose function
Copy Invoice Number in a cell
Then Use Vlookup Formula with applied steps
use iferror formula for any error removal
Design the Sheet as per required
Please subscribe the channel with below link:
/ @officegyan1346
Other Useful Videos :
Learn Macros :
• How to use Macro in Excel in Hindi | Macro...
Pivot Tables:
• How to use Pivot Table in Excel in Hindi |...
Conditional Formatting:
• How To Use Conditional Formatting In MS Ex...
#exceltips #officegyan #exceltutorial