So I have list of hundreads of datas based on baseball positions.
There are three positions I am lookg for, 1B, 2B, 3B, SS. Let's say A1-A10 I have postions. C1-C4 a table showing only those postions.
The criteria is If A1 is either, 1B,2B,3B,SS give me "1", if not 0, and alongside i need to use if error.
I have this so far but it isn't working: =IFERROR(IF(A1,C1:C4,1,FALSE),1),0). Could you guys help me please.
Thanks
Aucun commentaire:
Enregistrer un commentaire