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

CATEGORY - Information Formulas VERSION - 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