| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP
I am using VLOOKUP and when that function doesn't find the value in the
table, it returns "#NA" as the value. I then can't sum the column because of the #NA in some of the cells. Is there a way that I can return a zero or a null instead of the #NA? I was thinking that perhaps the VLOOKUP could be combined with IF... Thanks for your help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
| How do I combine If and VLookup function? | Excel Worksheet Functions | |||
| Help with VLookup function | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| How to combine a vlookup with a sumif function!!! | Excel Discussion (Misc queries) | |||
Threaded Mode
