Formula IF(OR

[Jon Johny]

I have a formula construction question. Below is the formula I have. (I am looking up the number of wins a certain team has). The lookup is looking this team up on the 'Team1' range, however, sometimes the team I am looking up may not be in this range and on the 'Team2' range, or in the 'Team3' range. How do I incorporate Team2 and Team3 ranges into this formula??

I think this is IF(OR(

Thank you

=IF(ISERROR(VLOOKUP($A3,Team1,2,FALSE)),"0",VLOOKUP($A3,Team1,2,FALSE))

 

[Jon Johny]

I'd prefer to use and modify this formula,

=IF(ISERROR(VLOOKUP($A3,Team1,2,FALSE)),IF(ISERROR(VLOOKUP($A3,Team2,2,FALSE)),IF(ISERROR(VLOOKUP($A3,Team3,2,FALSE)),0, VLOOKUP($A3,Team3,2,FALSE)),VLOOKUP($A3,Team2,2,FALSE)),VLOOKUP($A3,Team1,2,FALSE))

I just need this formula when team 3 is not included. I simply deleted the last condition (team3) but I got an N/A error. Im assuming Im missing some brakcet or other...

How do I do this?

 

[schielrn]

Maybe this:

=IF(ISERROR(VLOOKUP($A3,Team1,2,FALSE)),IF(ISERROR(VLOOKUP($A3,Team2,2,FALSE)),0,VLOOKUP($A3,Team2,2,FALSE)),VLOOKUP($A3,Team1,2,FALSE))

Hope that helps.