its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but "out 10
geeitn the id for 2 employees id "
Thanks,
On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote:
> HI,
> i think solved your quetions.
> otherwise revert me.
> Regards
> Pra
hope you will get most of ids from these formula's
c2 = VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",B:B,1,0)
d2 = VLOOKUP("*"&RIGHT(A2,LEN(A2)-FIND("~",SUBSTITUTE(A2,"
","~",LEN(A2)-LEN(SUBSTITUTE(A2," ",""),B:B,1,0)
On Tue, Jul 5, 2011 at 9:58 PM, ICWAI Help wrote:
> Search the employee name in
