new books formula

[kylefoley76]

I need to revise this formula and a second condition

=IF(COUNTIF([charts.xlsm]books!$A$1:$A$173,K1493),"#",1)

if a cell in k is blank then i need to mark a #
or if a cell in k matches books!a1:a173 then mark a # which it already does

otherwise, mark a 1

 

[Marcelo Branco]

Maybe

=IF(OR(K1493="",COUNTIF([charts.xlsm]books!$A$1:$A$173,K1493)),"#",1)


M.

 

[kylefoley76]

thanks, got it

 

[T. Valko]

I need to revise this formula and a second condition

=IF(COUNTIF([charts.xlsm]books!$A$1:$A$173,K1493),"#",1)

if a cell in k is blank then i need to mark a #
or if a cell in k matches books!a1:a173 then mark a # which it already does

otherwise, mark a 1

COUNTIF requires that the referenced file be open in order to work properly. You can accomplish the same task without the referenced file needing to be open like this...

=IF(K1493="","#",IF(COUNT(MATCH(K1493,[charts.xlsm]books!$A$1:$A$173,0)),"#",1))