mercredi 5 octobre 2016

If Error+ If + VlookUp

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