Vlookup with trim help

[spanspace]

Someone smarter then me help me figure out why this will not work. My only guess is it's adding quotes around the number after its been trimmed.

Excel Workbook
	B	C	D
6	PSID		Name
7	1012916		#N/A
Lookup 2

Excel 2010

Cell Formulas
Range	Formula
D7	=VLOOKUP(TRIM(SUBSTITUTE(B7,CHAR(160),CHAR(32))),Data!$D$4:$F$213,2,FALSE)

 

[spanspace]

I figured it out. Go figure...rack my brain and post I need help then figure it out right after I do. If anything I hope this helps someone else.

Excel Workbook
	B	C	D
6	PSID		Name
7	2162095		ME
Lookup 2

Excel 2010

Cell Formulas
Range	Formula
D7	=IF(A7="",IFERROR(IF(B7="","",VLOOKUP(TRIM(SUBSTITUTE(B7,CHAR(160),CHAR(32)))+0,Data!$D$4:$Z$1000,2,FALSE)),"No Match"),IFERROR(IF(A7="","",VLOOKUP(TRIM(SUBSTITUTE(A7,CHAR(160),CHAR(32)))+0,Data!$C$4:$F$1000,3,FALSE)),"No Match"))