» How to change error result calculation when using Vlookup formula to 0 or empty cell 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)							
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

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

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 3.75 Views: 35342

Engineer

Paul Balga Posted on: 31-12-1969

The null string "" is not the same as an empty cell. This still evaluates to 0 if used in further calculations.