» How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel

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)							
Result: 300	

Formula in cell E3: =VLOOKUP(C1,A1:B5,2,FALSE)	
Result: #N/A	

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

Formula in cell E5: =IF(ISERROR(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 change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel