hey everyone, i am pretty clueless when it comes to excel so I hope this
question makes sense or is possible

I am making an excel spreadsheet for the upcoming World Cup and have a
question...is it possible to have the text someone enters in a cell
show up in a completely different cell?

for instance, players will pick two teams to advance from each
group...say they put Mexico in cell D4....can the word Mexico
automatically show up in a different cell from a forumla, say J9? so
if someone different entered USA, then in their bracket USA would end
up in that cell...

make sense?


--
upper90
------------------------------------------------------------------------
upper90's Profile: http://www.excelforum.com/member.php...o&userid=35025
View this thread: http://www.excelforum.com/showthread...hreadid=547664