Any Excel Gurus in here?

Discussion in 'The Bar' started by Stan Beeman, Apr 29, 2014.

  1. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
    I need some help...
     
  2. Oderus

    Oderus Going to hell VIP

    Reputations:
    635
    Joined:
    Aug 21, 2012
    Messages:
    55,718
    Likes Received:
    3,738
    what are you trying to do?
     
  3. Kanye West

    Kanye West Yeezus!

    Reputations:
    21
    Joined:
    Dec 23, 2011
    Messages:
    120,890
    Likes Received:
    24,049
    RIP Guru

    [​IMG]
     
  4. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,947
    Joined:
    Sep 23, 2010
    Messages:
    47,109
    Likes Received:
    19,994

    RIP :fail:
     
  5. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    79,233
    Joined:
    Jan 18, 2012
    Messages:
    148,778
    Likes Received:
    76,861
    I'm fluent in excel but wouldn't call myself a guru.
     
  6. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    79,233
    Joined:
    Jan 18, 2012
    Messages:
    148,778
    Likes Received:
    76,861
    plus anything you don't know how to do you just look up on google and can figure it out.
     
  7. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
    I need something like this...

    If an email address in column B, matches an email in (another tab in same worksheet, column B), replace that cell with (2nd tab of worksheet, column C, that was the match to the column B, same row).
     
  8. Kanye West

    Kanye West Yeezus!

    Reputations:
    21
    Joined:
    Dec 23, 2011
    Messages:
    120,890
    Likes Received:
    24,049
    :wtf:
     
  9. Divorce Chicken

    Divorce Chicken Willy one plunge VIP

    Reputations:
    27,201
    Joined:
    Jan 24, 2012
    Messages:
    17,384
    Likes Received:
    39,870
    TIP: * = x
     
  10. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,947
    Joined:
    Sep 23, 2010
    Messages:
    47,109
    Likes Received:
    19,994
    This is exactly why I didn't respond. I figured it must be some big ass problem if he didn't google it.

    Cmon Booger, tell us what it is.
     
  11. Lou Loomis

    Lou Loomis Feel the Gern

    Reputations:
    6
    Joined:
    Aug 7, 2012
    Messages:
    17,244
    Likes Received:
    9,718
    [video=youtube;3QB74T4YGgo]http://www.youtube.com/watch?v=3QB74T4YGgo[/video]
     
  12. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
    maybe an example would help...

    All in same worksheet.
    Worksheet 1 = email addresses
    Worksheet 2 = email addresses with first and last name

    I need the last names on Worksheet 2 placed in Worksheet 1
    The emails in Worksheet 1 do not correspond in any order to Worksheet 2.

    Thus, if email in worksheet one of dick@abc.com matches email in worksheet two of dick@abc.com, I want dicks last name (which is only in worksheet 2), to be filled into that cell.

    Crystal clear right?
     
  13. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    79,233
    Joined:
    Jan 18, 2012
    Messages:
    148,778
    Likes Received:
    76,861
    Seems like something you would do in Access. But you can't use the Find and replace tool?
     
  14. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
    its not really a find and replace issue. If one cell matches another cell, I want a THIRD cell placed in the blank cell
     
  15. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,947
    Joined:
    Sep 23, 2010
    Messages:
    47,109
    Likes Received:
    19,994
    Maybe somebody else understood it better. Is this it?

    If
    Tab a b1=, gwartney@bigdick.com
    and
    Tab b b1=, gwartney@bigdick.com

    replace contents of Tab b b1 with contents of tab b c1, gwartney@itsnotthatbig.com
     
  16. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
    I need to go lay down - my brain hurts. I will return - hopefully with an answer ITT
     
  17. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    79,233
    Joined:
    Jan 18, 2012
    Messages:
    148,778
    Likes Received:
    76,861
    that's beyond my level...but I wouldn't use excel for an email database I would use Access.
     
  18. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,947
    Joined:
    Sep 23, 2010
    Messages:
    47,109
    Likes Received:
    19,994
    I'd be surprised if that can be done in Excel. I'll hang up and listen.
     
  19. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    16,134
    Joined:
    Apr 16, 2012
    Messages:
    26,482
    Likes Received:
    11,843
  20. Lou Loomis

    Lou Loomis Feel the Gern

    Reputations:
    6
    Joined:
    Aug 7, 2012
    Messages:
    17,244
    Likes Received:
    9,718
    [video=youtube;sBVq3RQApCM]http://www.youtube.com/watch?v=sBVq3RQApCM[/video]