+ Reply to Thread
Results 1 to 9 of 9

If Cell A2 = D2 place B2 in G2

  1. 05-18-2015, 06:13 PM #1
    senaida
    senaida is offline
    Registered User
    Join Date
    05-18-2015
    Location
    austin
    MS-Off Ver
    2007
    Posts
    2

    If Cell A2 = D2 place B2 in G2

    Is there a way to make this happen in Excel or do I have to use ACCESS ???

    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 05-18-2015, 06:19 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: If Cell A2 = D2 place B2 in G2

    In G2, enter this...

    =IF(A2=D2,B2,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 05-18-2015, 06:19 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,696

    Re: If Cell A2 = D2 place B2 in G2

    You would have to put a formula in cell G2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 05-18-2015, 06:20 PM #4
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: If Cell A2 = D2 place B2 in G2

    G2:
    =if(A2=D2,B2,"")

    Edit: Is there an echo in here?
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  5. 05-18-2015, 06:22 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: If Cell A2 = D2 place B2 in G2

    Daffodil, I was thinking teh very same thing...same thing...thing
    Reply With QuoteRegister To Reply
  6. 05-18-2015, 06:25 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,696

    Re: If Cell A2 = D2 place B2 in G2

    what the ... what ... wha ...
    Reply With QuoteRegister To Reply
  7. 05-18-2015, 06:26 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,696

    Re: If Cell A2 = D2 place B2 in G2

    At least we all came up with the same formula. Could have been embarrassing otherwise
    Reply With QuoteRegister To Reply
  8. 05-18-2015, 06:35 PM #8
    senaida
    senaida is offline
    Registered User
    Join Date
    05-18-2015
    Location
    austin
    MS-Off Ver
    2007
    Posts
    2

    Re: If Cell A2 = D2 place B2 in G2

    Thanks!!!
    Just to make things a little more confusing .....
    What if the number (student id, in my case) in A2 does not fall in D2 but rather somewhere else in column D? I still need that data from B2 to go to the corresponding row in column G.
    Example:
    A2 has 1234 (student id varies) B2 has 100 (grade varies)
    On my roster student 1234 is on D7 and I need the 100 from B2 to go to G7 ????
    Sorry I know it's confusing ... Well at least to me
    Would this be a VLookup formula ???
    Reply With QuoteRegister To Reply
  9. 05-18-2015, 06:45 PM #9
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: If Cell A2 = D2 place B2 in G2

    VLOOKUP, INDEX, LOOKUP, all viable candidates.

    =VLOOKUP(D2,$A$2:$B$500,2,0) and copy down
    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] code to recognize text in a cell and place corresponding info in adjacent cell
    By m1980rae in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2013, 05:05 PM
  2. Take Names from 1 cell and place in another cell based on criteria from 3rd cell
    By aesirian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 09:28 AM
  3. Automatically place date and time in one cell when another cell has any data entered.
    By sameredith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2012, 07:49 PM
  4. automaticly place the person in 1st, 2nd, 3rd etc. place according to the result of t
    By sync in forum Excel General
    Replies: 2
    Last Post: 06-24-2007, 10:16 AM
  5. Big sheet..neeed to jump from place to place
    By RHagerty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2007, 07:48 AM

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