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:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
    I need some help...
     
  2. Oderus

    Oderus Going to hell VIP

    Reputations:
    954
    Joined:
    Aug 21, 2012
    Messages:
    55,743
    Likes Received:
    3,787
    what are you trying to do?
     
  3. Kanye West

    Kanye West Yeezus!

    Reputations:
    27
    Joined:
    Dec 23, 2011
    Messages:
    120,890
    Likes Received:
    24,051
    RIP Guru

    [​IMG]
     
  4. gwartney

    gwartney Is there gas in the car? Gold

    Reputations:
    38,116
    Joined:
    Sep 23, 2010
    Messages:
    50,350
    Likes Received:
    24,146

    RIP :fail:
     
  5. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    138,609
    Joined:
    Jan 18, 2012
    Messages:
    156,939
    Likes Received:
    87,087
    I'm fluent in excel but wouldn't call myself a guru.
     
  6. BrulesRules

    BrulesRules Just grab 'em in the biscuits VIP

    Reputations:
    138,609
    Joined:
    Jan 18, 2012
    Messages:
    156,939
    Likes Received:
    87,087
    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:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
    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:
    27
    Joined:
    Dec 23, 2011
    Messages:
    120,890
    Likes Received:
    24,051
    :wtf:
     
  9. Divorce Chicken

    Divorce Chicken Willy one plunge

    Reputations:
    36,916
    Joined:
    Jan 24, 2012
    Messages:
    18,279
    Likes Received:
    42,120
    TIP: * = x
     
  10. gwartney

    gwartney Is there gas in the car? Gold

    Reputations:
    38,116
    Joined:
    Sep 23, 2010
    Messages:
    50,350
    Likes Received:
    24,146
    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:
    9
    Joined:
    Aug 7, 2012
    Messages:
    17,244
    Likes Received:
    9,719
    [video=youtube;3QB74T4YGgo]http://www.youtube.com/watch?v=3QB74T4YGgo[/video]
     
  12. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
    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:
    138,609
    Joined:
    Jan 18, 2012
    Messages:
    156,939
    Likes Received:
    87,087
    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:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
    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? Gold

    Reputations:
    38,116
    Joined:
    Sep 23, 2010
    Messages:
    50,350
    Likes Received:
    24,146
    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:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
    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:
    138,609
    Joined:
    Jan 18, 2012
    Messages:
    156,939
    Likes Received:
    87,087
    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? Gold

    Reputations:
    38,116
    Joined:
    Sep 23, 2010
    Messages:
    50,350
    Likes Received:
    24,146
    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:
    4,882
    Joined:
    Apr 16, 2012
    Messages:
    27,414
    Likes Received:
    13,275
  20. Lou Loomis

    Lou Loomis Feel the Gern

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