Combining lists - V Look Up - need help

[realestateexcel]

Hi,

Thank You in advance for reading this and the help. I am not an expert in excel. I am sure this is an easy formula but I can not get it to work. I have two list that I am trying to combine. I would like the formula to search the list to the left and return the phone number for the matching addresses. If there is no matching address NA is fine. This is wha tI am using and its not working. <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}span.s2 {color: #006107}</style>
=VLOOKUP(L3,B$3:C$13,2,0)

ADDRESS	PHONE				Phone Numbers	Address
10012 BERTEAU AVE	3122966829	Cell Phone			#N/A	1000 W 20th Pl
1003 W 19TH ST	3123304823	Cell Phone			#N/A	10012 Berteau Ave
1007 W 16TH ST	3122434984	Landline			#N/A	1002 W 20th Pl
1009 W 19TH ST	3125501344	Cell Phone			#N/A	1002 Wright Ave
1009 W 20TH PL	3129657436	Cell Phone			#N/A	1003 W 19th St
1009 W 32ND ST	7738431819	Cell Phone			#N/A	1003 W Cullerton St
1014 W 20TH PL	3123303141	Cell Phone			#N/A	10043 S Longwood Dr
1015 W 18TH PL	3122173190	Cell Phone			#N/A	1005 N Wolcott Ave #2
1015 W 31ST PL	8479420695	Cell Phone			#N/A	1006 W 20th Pl
1016 W 20TH PL	3127580611	Cell Phone			#N/A	1007 W 16th St
1016 W CULLERTON ST	7737442170	Cell Phone			#N/A	1009 W 19th St
					#N/A	1009 W 20th Pl
					#N/A	1009 W 32nd St
					#N/A	1012 W 31st Pl
					#N/A	1012 W 31st St
					#N/A	1013 W 18th Pl
					#N/A	1013 W 18th Pl
					#N/A	1013 W 18th Pl
					#N/A	1013 W 18th Pl
					#N/A	1013 W 31st St
					#N/A	1014 W 20th Pl

<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

Copying your sample data and formulas, I get 7 matches returning the phone numbers, and the rest are #N/A.
If you are not getting any matches, it means that the data that you think matches really doesn't. It is important to remember that it must match EXACTLY (except upper case/lower case doesn't matter). Something as simple as an extra space at the beginning or end of one of the entries is enough to make it not match.

In your example, it appears that "10012 Berteau Ave" is in cells L4 and B3. So that should be a match. If it is not returning one for you, enter these two formulas anywhere on your sheet.
=LEN(B3)
=LEN(L4)

They should both return 17. If they both do not, they the larger one has some extra spaces in there.