| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get rid of N/A in cells while using VLOOKUP in Excel
I have set up a page that will extract information from another workbook
using vlookup, the information also has a cost assigned to it but I can't get a running total of the items because the cells I'm not using have #N/A in them. Is there any way to clear the cells of #N/A but not erase the formula so that as I enter information I can see what the running cost is at the bottom? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
| Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Threaded Mode
