+ Reply to Thread
Results 1 to 14 of 14

Matching data in multiple cell

  1. #1
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Smile Matching data in multiple cell

    Hi
    Can anybody pls help on this

    I want to select 2 separate values from the dropdown list in column G and H.
    These 2 values, which mach the data with column A(1:10) and B(1:10) having same
    sequence should return a value "true" in column C. I mean Corresponding value of Cell G1 and Cell H1 should be similar with the Cells in Column A and B.

    For Example If G1 & H1 is similar to A3 and B3 then C3 is True
    Did I explain it properly
    Thanks for an answer.
    Last edited by pal_slg; 09-22-2011 at 01:54 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Matching data in multiple cell

    Can you upload example workbook with your input and desired output?

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    Hello and welcome to the forum,

    If you just want True or False then maybe something like:

    Please Login or Register  to view this content.
    If its more complicated than this then it would nice if you could post a dummy workbook.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Matching data in multiple cell

    Quote Originally Posted by zbor View Post
    Can you upload example workbook with your input and desired output?
    Thanks for offering help. Here is the worksheet. You can find drop down menu in Column G and H. I have selected G1 as "DRJ and H1 as RGB and it should automatically return a value TRUE in C18 (Marked in Yellow) as the corresponding cell value is also DRJ in A18 and RGB in B18.

    Thank you for your time
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    Same approach as in my previous post:

    Please Login or Register  to view this content.
    Just make sure you know which cells you are comparing. If all you want is True or False then if you say Cell 1 = Cell 2 AND Cell 3 = Cell 4 then Excel will check those two questions and return 'True' if both statements are correct or 'False' if one or both statements are not correct. The trick here is to make sure you put the correct cell references in the equations.

    abousetta
    Last edited by abousetta; 09-19-2011 at 03:44 PM. Reason: Further description of solution

  6. #6
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Matching data in multiple cell

    Quote Originally Posted by abousetta View Post
    Same approach as in my previous post:

    Please Login or Register  to view this content.
    Just make sure you know which cells you are comparing. If all you want is True or False then if you say Cell 1 = Cell 2 AND Cell 3 = Cell 4 then Excel will check those two questions and return 'True' if both statements are correct or 'False' if one or both statements are not correct. The trick here is to make sure you put the correct cell references in the equations.

    abousetta
    Hi
    Thanks a lot. But I think I could not make my problem clear. I have attached the file again with some remarks and example hoping that it may help to understand.
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    Attempt #2:

    Please Login or Register  to view this content.
    in cell C1 and drag down.

    Potential issues:

    You cannot have more than one dropdown menu chosen for G and H at the same time because the results may be wrong. For example, select "DRJ" and "GNG" in G1 and H1 and C10 = True. Now select "DRJ" and "GNG" in G1 and H5 and C10 is still True even though they are on different rows.

    Does satisfy your needs?

    abousetta

  8. #8
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Thumbs up Re: Matching data in multiple cell

    Quote Originally Posted by abousetta View Post
    Attempt #2:

    Please Login or Register  to view this content.
    in cell C1 and drag down.

    Potential issues:

    You cannot have more than one dropdown menu chosen for G and H at the same time because the results may be wrong. For example, select "DRJ" and "GNG" in G1 and H1 and C10 = True. Now select "DRJ" and "GNG" in G1 and H5 and C10 is still True even though they are on different rows.

    Does satisfy your needs?

    abousetta
    That has solved my problem. Thanks a lot!!

  9. #9
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    No problem. If you are satisfied with the results then please mark the thread as Solved.

    Good Luck.

    abousetta

  10. #10
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Matching data in multiple cell

    Quote Originally Posted by abousetta View Post
    No problem. If you are satisfied with the results then please mark the thread as Solved.

    Good Luck.

    abousetta
    Oops Sorry, I should have done this but pls can you guide me how to. I could not find the icon which will show it as SOLVED. Also How can I post a new thread. the New Thread Icon is not visible. May be I got confused.
    Thanks for your help again.

  11. #11
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    Hi,

    The instructions for marking the thread as Solved are on the forum rules (#9).

    You can start a new thread by going to the home page of the respective section you want to post the thread in (e.g. http://www.excelforum.com/excel-new-users/).

    Good luck.

    abousetta

  12. #12
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Thumbs up Re: Matching data in multiple cell

    Quote Originally Posted by abousetta View Post
    Hi,

    The instructions for marking the thread as Solved are on the forum rules (#9).

    You can start a new thread by going to the home page of the respective section you want to post the thread in (e.g. http://www.excelforum.com/excel-new-users/).

    Good luck.

    abousetta
    Thank you so much

  13. #13
    Registered User
    Join Date
    09-08-2011
    Location
    kolkata,india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Matching data in multiple cell

    hii i have a problem please some body help me out:

    I have datas in 2 sheets:

    sheet 1 sheet 2

    Name number Name number

    a 1235 a 1235
    b 5689 b 5689
    c 9876 c 9876
    d 9876 d 9879
    e 8796 e 8796

    the names and numbers are same in both the sheets except name d is entered wrongly in sheet 2(9879).my question is how can i use v lookup to determine that the name d in sheet 2 has been entered wrongly, suppose its a huge sheet with many names and numbers so its impossible to track with ***** eye.please somebody help me out

  14. #14
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Matching data in multiple cell

    Hi jaydeep,

    Please start a new thread (and take a look at the other forum rules) and send me a PM so I can take a look at it.

    Thanks.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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