True False from different sheets?

[kjglen]

Hi all

So glad I came across this forum hopefully I can help others too, I'm not excellent at excel but good at some things like pivot tables... anyway I need some help if possible?

I have a spreadsheet with two different sheets, I need to compare them and if they match a TRUE will show and if not a FALSE!!

So in sheet 1 I need to combine column A and C with Sheet 2 column B and D

can this be done? thanks so much for the help?

[crissandraauree]

For sheet 1, put this formula in column d:
=if(a1=c1,"true","false")

note that this will not know the difference between upper case and lower case letters

[kjglen]

Hi Crissandaauree

Thanks for your reply

I don't know if I explained this well... my apolgoies

So Column A and C in sheet 1 need to match with columns B and D in sheet 2

[Fotis1991]

A small sample workbook with your expected results will be usful.

[kjglen]

Hi Fotis

I have attached a sample....

So sheet1 Column A and B needs to Match Sheet2 Column A & B

So for example A1 and B1 in sheet 1 matches A33 and B33 in Sheet 2, is there a way it can do this for me...?

thanks

[Fotis1991]

So for example A1 and B1 in sheet 1 matches A33 and B33 in Sheet 2, is there a way it can do this for me...?

thanks

Are you sure that you uploaded the correct sample? Because:

In your sample row 33 of sheet2! is empty!

Looks like no match at all for any row..

[kjglen]

Stressed :/

Sorry Fotis

Hopefully it now shows

There is countless ones that will match, but there not in order, just using this as an example

[Fotis1991]

Do you mean?

=SUMPRODUCT((Sheet2!$A$1:$A$33=A1)*(Sheet2!$B$1:$B$33=B1))>0

OR?

=OR(COUNTIF(Sheet2!$A$1:$A$33,A1),COUNTIF(Sheet2!$B$1:$B$33,B1))>0

In D1 and copy down.

[kjglen]

It shows TRUE in every cell, but there is only one MATCH..... so there should only be 1 TRUE?

[Fotis1991]

...........................

[kjglen]

Clearly didn't do the formula correctly..... thank you so much

You are a legend

[Fotis1991]

................................