+ Reply to Thread
Results 1 to 11 of 11

Looking for data which has identic value in other columns

  1. #1
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Looking for data which has identic value in other columns

    Hi,

    I have 2 sheets, Sheet A & Sheet B:

    Sheet A has 3 Columns:

    Sheet A.png


    Sheet B has 3 Columns:

    Sheet B.png


    Now I need to looking for values of column C in Sheet B and return the correspond value only if B(n) is equal to C(n).

    Could you please guide me for the best formula for a large data workbook?

    Thanks in advance.
    Last edited by omid020; 05-23-2020 at 01:45 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    573

    Re: Looking for data which has identic value in other columns

    Hmmm, a little confused. Are you looking at Sheet B based on what's in Col A and Col B from Sheet A? And if you only bring back the value if B(n) = C(n) then why look in Sheet B? Maybe the above example isn't detailed enough. The value in C for Sheet A would have to be 1.2 whether I looked it up in Sheet B or not?
    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Looking for data which has identic value in other columns

    Yup,the value in C for Sheet A would have to be 1.2 for XYZ.

  4. #4
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    573

    Re: Looking for data which has identic value in other columns

    Then why do a lookup if that's the only value it can be?

  5. #5
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Looking for data which has identic value in other columns

    Quote Originally Posted by Gregb11 View Post
    Then why do a lookup if that's the only value it can be?
    Mmm, I don't want to have 0.1 instead.

  6. #6
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    573

    Re: Looking for data which has identic value in other columns

    You won't. In cell C1 just enter
    =B1

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    5,143

    Re: Looking for data which has identic value in other columns

    May be:

    =IF(COUNTIFS(SheetB!$A$1:$A$2,A1,SheetB!$B$1:$B$2,B1,SheetB!$C$1:$C$2,B1),B1,"No Match")

  8. #8
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Looking for data which has identic value in other columns

    What if B1 in Sheet A is not equal to B1 in Sheet B?

  9. #9
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Looking for data which has identic value in other columns

    Please kindly view the attachment, It may declare what I need.
    Attached Files Attached Files

  10. #10
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    5,143

    Re: Looking for data which has identic value in other columns

    Try in C2:

    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Looking for data which has identic value in other columns

    Quote Originally Posted by bebo021999 View Post
    Try in C2:

    Please Login or Register  to view this content.
    It works like charm! Thank you.

+ 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