» How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
CATEGORY - Information Formulas
VERSION - All Microsoft Excel Versions
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 celllearn more about Vlookup formula by pressing Vlookup

Book Store:
Recommended Books:
- Special Edition Using Microsoft Excel 2002
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Reporting and Analysis (2nd Edition)
No comments have been submitted.

