Dear experts
i have master in mastertab and want to vlookup into multiple sheet(EMAE,JAPC,US) from cellL11 till end of value in F
from lookup value of 4 delimited value of trim code after hypeb.
for E.G Like !! Vlookup(""0062&290001&S0044&0000"",[Master!B$2:E$],4,0) But lookup value in range combination is 0062-290001-0-XM000-0000 extra is ""0"" after second hypen)
i want formula or code for this action please help on this.
find the attachment
Last edited by julielara; 02-26-2016 at 03:35 AM. Reason: missing
Hi julielara,
maybe so (in cell N24 sheet 'US')
Formula:
Please Login or Register to view this content.
thanks nilen but some cases instead of -0- 6 digit value come like 0062-290001-451425-XM000-0000 that why i want avoid -0- is there possible vlookup without 0 ? any vba code help in this?
Try
=IFERROR(VLOOKUP($F24&"-"&$H24&"-0-"&$I24&"-"&$J24,Master!$B$2:$E$1000,4,0),IFERROR(VLOOKUP($F24&"-"&$H24&"-"&$I24&"-"&$J24,Master!$B$2:$E$1000,4,0),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks