Looking for data which has identic value in other columns

1. 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?

2. 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?

3. 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. 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. Re: Looking for data which has identic value in other columns

Originally Posted by Gregb11
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. Re: Looking for data which has identic value in other columns

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

7. 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. 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. Re: Looking for data which has identic value in other columns

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

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

Try in C2:

``Please Login or Register  to view this content.``

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

Originally Posted by bebo021999
Try in C2:

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

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