i'm trying to complete a simple hockey pool excel sheet but having an issue with a formula. I basically have a formula that says: =IF(C3:C202="TBL",('Amount of Games'!B3),"")
This is doing what I want but with one team. it is basically saying if this range of cells says TBL copy the cell from the other page. What I want to do is put multiple variables in there. I want it to say if any of these cells say TBL copy this cell but if any of these cells say BOS copy this other cell, but if any of these cells say CAR then copy this other cell... etc. etc. I can't seem to figure out the variable to have multiple cells as a choice. there seems to be a true false options and no if/else/then.
any help would be appreciated.
This is doing what I want but with one team. it is basically saying if this range of cells says TBL copy the cell from the other page. What I want to do is put multiple variables in there. I want it to say if any of these cells say TBL copy this cell but if any of these cells say BOS copy this other cell, but if any of these cells say CAR then copy this other cell... etc. etc. I can't seem to figure out the variable to have multiple cells as a choice. there seems to be a true false options and no if/else/then.
any help would be appreciated.