VLOOKUP with return of partial result

[virtuosok]

Hi,
I have the formulas in the following format:

=VLOOKUP(K3,IWRS003!A2:B800,2,FALSE)

They return result along the lines of
Smith, John
I need the formula to only return the value before comma (Smith) but struggle to marry the above formula with the likes of

=LEFT(A1,(FIND(",",A1,1)-1))

Is it even possible or I have to add helper column?

 

[etaf]

try

=LEFT(VLOOKUP(K3,A2:B800,2,FALSE),(FIND(",",VLOOKUP(K3,A2:B800,2,FALSE),1)-1))

Book6
	A	B	C	D	E	F	G
1				smith, john		smith
2	1	ABC,123		Vlookup		Just text before comm
3	2	smith, john				ABC
4
Sheet2

Cell Formulas
Range	Formula
D1	D1	=VLOOKUP(K3,A2:B800,2,FALSE)
F1	F1	=LEFT(VLOOKUP(K3,A2:B800,2,FALSE),(FIND(",",VLOOKUP(K3,A2:B800,2,FALSE),1)-1))
F3	F3	=LEFT(VLOOKUP(K4,A2:B800,2,FALSE),(FIND(",",VLOOKUP(K4,A2:B800,2,FALSE),1)-1))

 

[virtuosok]

Perfect, this works! Thanks a lot!

 

[etaf]

you are welcome