*Sorry, I had to re-post again. This one is working now.
Hello. I am hoping for some assistance with this problem I have.
Please see attached. The desired actions are in the initial sheet and the desired results are in the Desired Result sheet.
Any help would be much appreciated.
Last edited by uberathlete; 08-02-2015 at 07:07 PM.
Try this...
=VLOOKUP(LEFT(A2,10)&"*",$E$2:$F$7,2,0)
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
Hi FDibbins. Thank you for the suggestion. Unfortunately, the formula will not work in all instances because the partial part numbers are not always 10 characters long.
Hi uber,
Try this in B2 and pull down.
=VLOOKUP(LEFT(A2,FIND("G",A2)),$E$2:$F$7,2,FALSE)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try in B2
=LOOKUP(9.99E+307,SEARCH($E$2:$E$7,$A2),$F$2:$F$7)
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi MarvinP and Ace_XL. I tried both formulas but it doesn't seem to work completely when I use a bigger data set, like the attached. For example, B2 should return Acer A501 Iconia Tab instead of unknown .
My bad..Try
=LOOKUP(2,SEARCH($E$2:$E$793,$A2),$F$2:$F$793)
Works like a charm. Thanks Ace_XL!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks