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) |