# Lookup values in three columns, TRUE if they match another sheet (sumproduct?)

1. ## Lookup values in three columns, TRUE if they match another sheet (sumproduct?)

Hi guys,

I have 3 coloumns of data on 2 sheets.

On the first sheet I would like to add a 4th saying TRUE if the row of data is replicated on the other sheet, false if it doesn't match anywhere on the other sheet.

Attached is a basic example.

Simon

2. ## Re: Lookup values in three columns, TRUE if they match another sheet (sumproduct?)

Try:

=SUMPRODUCT(--('Should be'!\$A\$3:\$A\$10=A3),--('Should be'!\$B\$3:\$B\$10=B3),--('Should be'!\$C\$3:\$C\$10=C3))>0

3. ## Re: Lookup values in three columns, TRUE if they match another sheet (sumproduct?)

That's great, I thought it was a SUMPRODUCT but I haven't really explored that function completely.

It's really useful, thanks.

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

#### 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