I am looking for a macro to partial text match vlookup between two sheets.
Sheet1 - Monthly Report
Column A
Vijay
David
United States
Sheet 2 - Master
Column A
Vijayanand
Davidson
United States
I need a vlookup that will find any partial text in Monthly report matches in the master report. For eg. Vijay in monthly report is partially matched with Vijayanand in Master report.
Regards,
Vijay
Try
=INDEX(Master!A:A,MATCH('Monthly Report'!A2&"*",Master!A:A,0))
Last edited by Bob Phillips; 01-06-2011 at 05:35 AM.
can you outline where the results are being listed - it's not clear - and the order in terms of criteria and lookup_array is of importance re: solution.
If matching Monthly to Master as per Bob's post then see his example - going the other way around the approach would be different.
Last edited by DonkeyOte; 01-06-2011 at 05:37 AM. Reason: edit: modified per Bob's edit (addition of wildcards)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks