have cell b8 with team 1

         cell b10 with team 2

      if  cell c8 has a 2 need to fill cell d9 with cell c8 info

or if cell c10 has a 2 need to fill cell d9 with cell c10 info

if neither has a 2 need to have cell d9 blank.

if cell d9 has cell c8 info want cell b77 filled with cell c10 info or

if cell d9 has cell c10 info want cell b77 filled with cell c10 info

 any help or ideas have had it figured out if i put a hidden cell with an extra formula trying to not have that.

​have cell b8 with team 1         cell b10 with team 2      if  cell c8 has a 2 need to fill cell d9 with cell c8 infoor if cell c10 has a 2 need to fill cell d9 with cell c10 infoif neither has a 2 need to have cell d9 blank.if cell d9 has cell c8 info want cell b77 filled with cell c10 info orif cell d9 has cell c10 info want cell b77 filled with cell c10 info any help or ideas have had it figured out if i put a hidden cell with an extra formula trying to not have that.   Read More

​