+ Reply to Thread
Results 1 to 12 of 12

Need help with data inputted in a certain cell to output a certain name

  1. 07-20-2017, 06:02 PM #1
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Need help with data inputted in a certain cell to output a certain name

    Hello!

    I have been on here a million times you guys/gals are great!

    I am trying for the life of me to figure this out, I know its simple but please see what I am trying to do:

    Basically I have a crew that keeps a running excel spreadsheet of customers. I need for column A if it has a certain matched criteria of store number (ex: 223,114,720 will only be numbers) if the store number matches the assigned managers store - in column F display the managers name. How would I go about doing this?

    I have 7 managers - each assigned 8-12 stores a piece (referenced just by store number) If the store number matches, what was keyed in column A I need it to output the correct managers name in column F.

    I have attached a sample of what it looks like. Hope someone can help! Pulling hair out. :P

    Please let me know if I am making since.

    Thanks everyone!!!

    -Brandon
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-20-2017, 06:48 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need help with data inputted in a certain cell to output a certain name

    Your sample workbook has no sample data. Please provide all the information required to present an answer.

    1) Your lookup table with managers and associated store numbers
    2) Examples of the Column A data
    3) Examples of the expected results

    Be sure to think through all the scenarios your data might present... multiple stores IDs, multiple managers, etc.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 08-01-2017, 07:31 AM #3
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Re: Need help with data inputted in a certain cell to output a certain name

    Thank you for your reply!! Very sorry I havent replied sooner, please let me fill this information out and I will have to you shortly.

    Thanks!
    Reply With QuoteRegister To Reply
  4. 08-01-2017, 07:50 AM #4
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Re: Need help with data inputted in a certain cell to output a certain name

    Thank you everyone for all of your help! I know this is really small for you guys, but its been racking at my brain how to do such an easy command that would make our lives a whole lot easier.

    Any ideas? PLEASE feel free to revamp spreadsheet - I am open for any remods.

    Thank you wonderful ladies and gents!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-01-2017, 07:52 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: Need help with data inputted in a certain cell to output a certain name

    In F2 copied down:

    =INDEX($J$2:$J$71,MATCH(A2,$H$2:$H$71,0))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 08-01-2017, 07:56 AM #6
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Re: Need help with data inputted in a certain cell to output a certain name

    How would i make it possible for the #n/a to go away when no value is present?

    Thanks!!!!!!!!!!!!!
    Reply With QuoteRegister To Reply
  7. 08-01-2017, 07:57 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: Need help with data inputted in a certain cell to output a certain name

    Maybe:

    =IFNA(INDEX($J$2:$J$71,MATCH(A2,$H$2:$H$71,0)),"")
    Reply With QuoteRegister To Reply
  8. 08-01-2017, 08:03 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: Need help with data inputted in a certain cell to output a certain name

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  9. 08-01-2017, 08:05 AM #9
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Re: Need help with data inputted in a certain cell to output a certain name

    This worked BEAUTIFULLY! You are amazing and thank you so much again!! OMG. Would it be too much asking how I could get the cell to correspond with the color of the manager as well?

    Thank you AliGW!
    Reply With QuoteRegister To Reply
  10. 08-01-2017, 08:08 AM #10
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: Need help with data inputted in a certain cell to output a certain name

    You will need to set conditional formatting rules for the colour - one for each name in the list. It can't be automated without CF unless you resort to VBA. Happy to advise if you want to start a new thread, as it is a different query. Please mark this one as solved.
    Reply With QuoteRegister To Reply
  11. 08-01-2017, 08:10 AM #11
    therealdank
    therealdank is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Atlanta
    MS-Off Ver
    2012
    Posts
    6

    Re: Need help with data inputted in a certain cell to output a certain name

    Excellent, i can figure it out from here I closed out as solved and again thank you so much!
    Reply With QuoteRegister To Reply
  12. 08-01-2017, 08:11 AM #12
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: Need help with data inputted in a certain cell to output a certain name

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to auto populate one cell based on data inputted in another.
    By MIKETALEA in forum Excel General
    Replies: 3
    Last Post: 10-03-2014, 01:46 PM
  2. [SOLVED] Cell data dependant on inputted info
    By Mearsy in forum Excel General
    Replies: 3
    Last Post: 08-29-2012, 10:09 AM
  3. Change a value in a cell depending on the inputted value
    By datahouse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2011, 09:49 AM
  4. Autofill formula to cell below only after data is inputted
    By OneCleverTchr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2010, 03:31 PM
  5. AutoFill When A Cell Inputted With Data
    By esawah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2010, 02:36 AM
  6. [SOLVED] Calculating from last inputted cell
    By Petermac in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-31-2006, 09:15 AM
  7. calculating from last inputted cell
    By DAShields in forum Excel General
    Replies: 5
    Last Post: 03-03-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1