दोस्त Normal Vlookup आपने बहुत use किया होगा, लेकिन इस वीडियो में मैं आपको सिखाने वाला हूं Wild Card Vlookup के बारे में, Wild Card Vlookup से आप अपना डाटा बड़ी आसानी से निकाल सकते हैं
Watch This Video to Learn
More Important Ideas For You:
- 4 Ways-Combine & Merge Multiple Excel File Data into One with VBA Code
- How to Auto Color Cells in Excel Based on Value (Red – Green – Yellow)
- Excel Date Problem’s-Solution for Bank Statement
- EXCEL Trick – How to Divide the total amount in different- different random entries in excel
- Highlight Active Row and Column in Excel (Based on Cell Selection)
- [TOP 5] Excel Secret & Hidden Shortcut Keys to Work Faster
- Tally to Excel Data Export Problem and Solution
- Merge Multiple Excel File in to One File (by One click) VBA Code
- How to Apply Vlookup on Large / Big Data in Excel
- How to make Courier Charges Calculator in Excel | Shipping Charges Calculator
- Top10 – Excel HIDDEN Copy Paste Secrets for EXCEL PROs
- How to Calculate Minimum Value Greater than Zero “0” with Formula in Excel
- How to Select Automatic a Name from Column with Formula in Excel
- How to Calculate Petrol Conveyance with Formula in Excel Easily
- How to Enter All Sheets Monthly Total Summery in a New Sheet
- Enter Kgs and Liters Automatically in Excel Cells – by One Click
- Make Monthly Stock Sheet in Excel – (Opening Stock + Purchase – Sale = Closing Stock)
- How to Split Each Excel Sheet Into a Separate File by One Click
- Transpose Very Complicated Excel Data in to Easy Format 🔥🔥🔥
- Attendance Software Data Not Managed Properly in Excel | Convert Vertical Data to Horizontal Format in Excel
One query & one suggestion
What happens when wildcard vlookup for a part name of two companies are common eg. Reliance industries and Reliance Communications, if I wildcard vlookup for Reliance which one would it pick
Suggestion :for wildcard vlookup one can have two formulas one which would be from column 1 to show the complete name and second to show its address, so one is sure the output is as desired