| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returning #N/A
Thanks Peo...
-- Always provide your feedback... "Peo Sjoblom" wrote: This was not meant to be taken literally use =IF(ISNA(your_formula),"",your_formula) -- Regards, Peo Sjoblom "Michelle7890" wrote in message ... Do I need = in there somewhere- I am getting some sort fo formula error?? "Sheeloo" wrote: IF(ISNA(VLOOKUP()),"",VLOOKUP()) if you have Exel 2007 then IFERROR(VLOOKUP(),"") Replace VLOOKUP() with your VLOOKUP formula -- Always provide your feedback... "Michelle7890" wrote: 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 | |||
![Sheeloo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
