ExcelBanter - iserror help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - iserror help (https://www.excelbanter.com/excel-worksheet-functions/169594-iserror-help.html)

Scott@CW

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 03:49 AM.