+ Reply to Thread
Results 1 to 7 of 7

Replace text in one sheet with number value from another

  1. #1
    Registered User
    Join Date
    09-23-2017
    Location
    Arizona
    MS-Off Ver
    2016
    Posts
    3

    Replace text in one sheet with number value from another

    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

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Replace text in one sheet with number value from another

    Use a nested VLOOKUP, like this:

    =IFERROR(IFERROR(VLOOKUP(B2,Sheet2!$A$2:$B$11,2,FALSE),VLOOKUP(B2,Sheet3!$A$2:$B$11,2,FALSE)),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Replace text in one sheet with number value from another

    For quick response / better result, attach sample file with desired result.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    09-23-2017
    Location
    Arizona
    MS-Off Ver
    2016
    Posts
    3

    Re: Replace text in one sheet with number value from another

    Thanks so much. This is exactly what I'm looking for except I have no idea how to use a "nested" vlookup. Where do I put this formula?

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Replace text in one sheet with number value from another

    Take a look at the Excel sheet that I posted.... It has the raw data in the top few rows and the results (and formulae) a few rows below it. Yellow cells in sheet 1....

  6. #6
    Registered User
    Join Date
    09-23-2017
    Location
    Arizona
    MS-Off Ver
    2016
    Posts
    3

    Re: Replace text in one sheet with number value from another

    Thanks I figured it out. Very helpful

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Replace text in one sheet with number value from another

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Replace a Number with Text?
    By IPerry92 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2015, 12:36 PM
  2. How do I replace the number values with corresponding text ?
    By paul_drive in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-22-2013, 01:42 PM
  3. [SOLVED] Replace text number with some other number based on the sheet
    By amandeepsharma89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 09:52 PM
  4. Replies: 19
    Last Post: 06-13-2012, 09:03 AM
  5. Compare Text, Replace Number
    By sglick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2007, 05:04 PM
  6. Replace a number with text
    By Candy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2005, 01:05 PM
  7. [SOLVED] Replace Number with Text using Macro
    By Carter68 in forum Excel General
    Replies: 3
    Last Post: 04-19-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1