Vlookup with empty cell

**kmerid** · 10-09-2009, 12:27 PM

Mem# Pr First PR Last Sec First Sec Last Address 1 Add2 City State Zip Phone
123456 b h j h 2530 first st My Town TN 37771 xxx-xxx-xxxx
789123 d m k m 111 Main St apt 111 abc Fl 32536 xxx-xxx-xxxx
257846 j m v m 9th St. N.W. my town TN 37771 xxx-xxx-xxxx

=VLOOKUP(G3,reg2010!$H$2:$AY$156,2,FALSE) that is what i have in the city field but most do not have a add2 field then if blank pulls the city, state and zip for the same with all the blank add2 lines

**JBeaucaire** · 10-09-2009, 12:35 PM

Mem#	Pr First     PR Last	Sec First   Sec Last	Address 1	Add2	City	State	Zip	Phone
123456	  b		h	  j		h 	2530 first st	 	My Town	TN	37771	xxx-xxx-xxxx
789123	  d		m 	  k		m 	111  Main St	apt 111	abc	Fl	32536	xxx-xxx-xxxx
257846	  j		m 	  v		m 	9th St. N.W.	 	my town	TN	37771	xxx-xxx-xxxx

Your question is not really clear. Can you post a sample workbook showing examples of your desire results both with Add2 and without? Let us see where/how you're applying this formula and experiencing an issue.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**kmerid** · 10-09-2009, 01:21 PM

Attached is ss with info etc

Thanks

**JBeaucaire** · 10-09-2009, 01:49 PM

First, your VLOOKUP() formula is incorrect. IN cell B2, the formula needs to read:

=VLOOKUP($A2,reg2010!$B$2:$L$30,2,FALSE)

Notice the $ signs added? These serve to "lock" the references in place so they are correct as referenced in each cell. You're current use has incorrect range values in every cell except B2. Need to fix that.

Second, what's the problem? I asked you to show desired results and I don't see anything in the file you've noted as a problem. What's the issue?

**kmerid** · 10-09-2009, 02:51 PM

What I am attempting to do if the member nbr in sheet 2 to pull name, address, etc up to the phone from sheet 1 over to sheet 2 - that tells me they are registered and can then send information from that - eventually will be over 2000 registered in sheet 1 and sheet 2 are volunteers and need to verify they are registered