How to eliminate N/A error result when using Vlookup formula in Microsoft Excel

My Account

Check out

Shopping Cart

JOIN OUR NEWSLETTER
and receive for joining:
	Free eBook Learn More!
	Free Excel ADD-IN
	Free Weekly Excel Tip








F1 eBook (Spanish)

» How to eliminate N/A error result when using Vlookup formula in Microsoft Excel

CATEGORY: Information Formulas

VERSIONS: All Microsoft Excel Versions

Data in range A2:B6

	Column A	    	Column B	

Row2	adding			100		
Row3	Advanced Filter		200					
Row4	Amortization		300				
Row5	Array Formula		400	
Row6	AutoComplete		500				

Text in cell D2: 		Array
	
Formula in cell E2: =VLOOKUP(C1,A1:B5,2,FALSE)	
Result: #N/A	

Formula in cell E3: =IF(ISNA(VLOOKUP(D2,A2:B6,2)=TRUE),0,VLOOKUP(D2,A2:B6,2))		
Result: 300			

Formula in cell E4: =IF(ISNA(VLOOKUP(D2,A2:B6,2,FALSE)=TRUE),"",VLOOKUP(D2,A2:B6,2,FALSE))	
Result: Empty cell

learn more about Vlookup formula by pressing Vlookup

Screenshot // How to eliminate N/A error result when using Vlookup formula in Microsoft Excel