Hello,
I'm working on a wrestling game and the "moves" all have changing point values. I have three sheets total. Sheet one includes wrestler name(A), Move 1(B), Move 2(C), Move 3 (D) all the way to move 10. Sheet two contains the point values for 30 different moves (each user selects 5 of these). Sheet three contains values for 15 different moves (each user selects 5). How can I replace the move names in Sheet one with the move values in Sheets 2 and 3?
Sheet One:
Wrestler Name Move 1 Move 2 Move 3 Move 4 Move 5 Hulk Hogan Camel Clutch Airplane Spin DDT Leg Drop Elbow Smash Macho Man Brainbuster Airplane Spin Arm Lock Figure Four DDT
Sheet Two (Three is similar with different move names and values)
Move Value Airplane Spin 5 DDT 7 Head Lock 6 Figure Four 2 Camel Clutch 7 Piledriver 11 Brainbuster 13 Leg Drop 9 Monkey Flip 1 Reverse Chin Lock 7
Bookmarks