IF combined with OR for fixture template

['MMSA_MAX]

Hi All,

Ive attached the template and what I was looking for was something along the lines of

IF Cell A2 = 1 then (this team), or IF Cell A2 = 2 then (this team)....... and onwards.

I just want to be able to put the team names into a column and once a name is there it automatically picks it up so that way I can just copy and paste the formula down fixture.

Hope that makes sense

Regards

Max

[:) Sixthsense :)]

May be this?

In Row 3 cell


=IFERROR(VLOOKUP(A3,$K$2:$L$11,2,0),"")


Drag it down

['MMSA_MAX]

Thank you very much, worked an absolute treat