Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror help
Can someone please help with turning the below formula into an iserror. I
have tried several times but keep getting a format error. IF(VLOOKUP(--H21,$B$21:$B$200,1,FALSE),"No","Yes") Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror help
Not sure what "turning (the) formula into an iserror" really means, but
perhaps: =IF(ISNA(MATCH(--H21,$B$21:$B$200,FALSE)),"Yes","No") or =IF(COUNTIF($B$21:$B$200,--H21)0,"No","Yes") In article , Scott@CW wrote: Can someone please help with turning the below formula into an iserror. I have tried several times but keep getting a format error. IF(VLOOKUP(--H21,$B$21:$B$200,1,FALSE),"No","Yes") Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions | |||
Iserror & VBA | Excel Discussion (Misc queries) | |||
ISERROR | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |