I need to do a vlookup. But in my first sheet it may say Linda Inc. In the lookup sheet it says Linda. Can I do a lookup using just the first 5 values. vlookup(d2,sheetname,left5,0) for example
I need to do a vlookup. But in my first sheet it may say Linda Inc. In the lookup sheet it says Linda. Can I do a lookup using just the first 5 values. vlookup(d2,sheetname,left5,0) for example
Hi and welcome to the forum
Try this...
=vlookup(d2&"*",sheetname,5,0)
you had ,left5, in your formula, was that a typo or a range name? Because if not, then the column number need to be just that...a number
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks