I have this vlookup formula:
=IF(ISERROR(VLOOKUP(AS34,Inputs!$A$19:$B$30,2,0)),"",VLOOKUP(AS34,Inputs!$A$19:$B$30,2,0))
In another cell on the same row, I have this formula:
=IF($K$1=$M$33,COUNTA(M34),IF($K$1=$N$33,COUNTA(M34:N34),IF($K$1=$O$33,COUNTA(M34:O34),IF($K$1=$P$33,COUNTA(M34:P34),IF($K$1=$Q$33,COUNTA(M34:Q34),IF($K$1=$R$33,COUNTA(M34:R34),IF($K$1=$S$33,COUNTA(M34:S34),IF($K$1=$T$33,COUNTA(M34:T34),IF($K$1=$U$33,COUNTA(M34:U34),IF($K$1=$V$33,COUNTA(M34:V34),IF($K$1=$W$33,COUNTA(M34:W34),IF($K$1=$X$33,COUNTA(M34:X34),IF($K$1=$Y$33,COUNTA(M34:Y34),IF($K$1=$Z$33,COUNTA(M34:Z34),IF($K$1=$AA$33,COUNTA(M34:AA34),IF($K$1=$AB$33,COUNTA(M34:AB34),IF($K$1=$AC$33,COUNTA(M34:AC34),IF($K$1=$AD$33,COUNTA(M34:AD34),IF($K$1=$AE$33,COUNTA(M34:AE34),IF($K$1=$AF$33,COUNTA(M34:AF34),IF($K$1=$AG$33,COUNTA(M34:AG34),IF($K$1=$AH$33,COUNTA(M34:AH34),IF($K$1=$AI$33,COUNTA(M34:AI34),IF($K$1=$AJ$33,COUNTA(M34:AJ34),IF($K$1=$AK$33,COUNTA(M34:AK34),IF($K$1=$AL$33,COUNTA(M34:AL34),IF($K$1=$AM$33,COUNTA(M34:AM34),IF($K$1=$AN$33,COUNTA(M34:AN34),IF($K$1=$AO$33,COUNTA(M34:AO34),IF($K$1=$AP$33,COUNTA(M34:AP34),IF($K$1=$AQ$33,COUNTA(M34:AQ34))))))))))))))))))))))))))))))))
Because the vlookup returns a null text string, I cannot use COUNTA.
Bookmarks