Doesn't the formula I posted work - with sheet name added it would be
=LOOKUP(REPT("z",255),CHOOSE({1,2,3},"",VLOOKUP( Z46,Game1!$Y$15:$Z$21,2,0),VLOOKUP( Z46,Game1!$AF$15:$AG$21,2,0 )))
or perhaps simpler
=IF(Z46="","",VLOOKUP( Z46,IF(MOD(Z46,2),Game1!$Y$15:$Z$21, Game1!$AF$15:$AG$21),2,0))
Bookmarks