| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Vlook up returning N?A-Resolved
Well, thanks for feeding back, Andy.
Pete On Jan 19, 1:25*am, andy wrote: Pete_UK thanks for the help, *mark's a coworker and i have *new spreadsheet to use! *You rock! * -- andy "Pete_UK" wrote: You might have an empty cell in your table which is being found correctly, but Excel returns it as zero rather than "". Hope this helps. Pete On Jan 18, 7:01 pm, Mark wrote: In some cases it is returning <blank, as desired, and in other cases it returns "0". Does anyone know why?? "Roger Govier" wrote: Hi Andy Try =IF($A790, IF(ISNA(VLOOKUP($A79,'BO Output'!$A$3:$P$2002,4,FALSE)),"" ,VLOOKUP($A79,'BO Output'!$A$3:$P$2002,4,FALSE)),"") -- Regards Roger Govier "andy" wrote in message ... We are using the following formula and it returns N/A =IF($A790,IF(VLOOKUP($A79,'BO Output'!$A$3:$P$2002,4,FALSE)="","",VLOOKUP($A79,' BO Output'!$A$3:$P$2002,4,FALSE)),"") How do i use isna function with this formula -- andy- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOK up returning #N/A even though value exists in lookup array | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| Vlook | Excel Worksheet Functions | |||
| VLOOK | Excel Worksheet Functions | |||
Threaded Mode
