| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup error
Hello,
Using vlookup and when referencing a blank cell I am receiving a €˜0 I have tried using =IF(ISERROR(VLOOKUP(F15,Input!$1:$65536,N15,FALSE) )," ",VLOOKUP(F15,Input!$1:$65536,N15,FALSE)) however I am still receiving a 0. Any thoughts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup error
You could use something like =IF(VLOOKUP(F15,Input!$1:$65536,N15,0)<"",VLOOKUP (F15,Input!$1:$65536,N15,0),"") although that will still give #N/A! if F15 doesn't exist in the lookup range -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=505087 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup error - recognition of value | Excel Worksheet Functions | |||
| Fill down error for Vlookup | Excel Worksheet Functions | |||
| vlookup weird error | Excel Worksheet Functions | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| vlookup error | Excel Discussion (Misc queries) | |||
Linear Mode
