» 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:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Fall of Advertising and the Rise of PR
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Special Edition Using Microsoft Access 2002
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
Excellent Tip!
Ken Schneider Posted on: 31-12-1969
This tip worked just as written - thanks for saving me hours of time trying to fiture this out by myself!!!Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
