| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returning #N/A
I am using vlook up in a list of accounts that varies from week to week. How
can I make vlookup return a 0 or blank rather than the pesky N/A when a prticular account is not on the list for the week? The N/A is messing up my total lines? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP always returning the same value! | Excel Discussion (Misc queries) | |||
| Vlookup returning a YES or NO | Excel Worksheet Functions | |||
| Vlookup returning #n/a | Excel Worksheet Functions | |||
| vlookup returning a #N/A value | Excel Worksheet Functions | |||
| vlookup returning sum | Excel Worksheet Functions | |||
Threaded Mode
