Matching data from two sheets (two data sources)

[asajnani]

Hi there,
I'm comparing data from two different sources and need an efficient way to do it. I have one Excel workbook with two sheets - RAS EpSelect 0101-0106 and RAS HCP 0101-0106. Both worksheets have mostly the same data but is distributed over different columns.

The data I'm using has patient information and each patient has a unique ID (this is in both sheets). What I'd like to do is to check if the ID in cell A2 of RAS EpSelect 0101-0106 matches and ID in column T of RAS HCP 0101-0106 then look at whether cell P2 of RAS EpSelect 0101-0106 matches the correlating cell in column DG of RAS HCP 0101-0106.

Both IDs need to match and both figures in cell P2 and cell DG(number?) also need to match. I've tried this:

=IF(AND('RAS EpSelect 0101-0106'!A2='RAS HCP 0101-0106'!T:T,'RAS EpSelect 0101-0106'!P2='RAS HCP 0101-0106'!DG:DG), "No", "Yes")

I think it works but not sure if it's returning a "Yes" because it's an exact match or because it's found the same value somewhere in the column.

Ideally, I'd like to use this as a conditional format (highlight the cell if doesn't match the cell in the other cells) because I have many cells to apply this to but happy to just insert a column.

Thanks for your help!!!

 

[ChrisR]

Hi,

Try this

=Match('RAS EpSelect 0101-0106'!A2,'RAS HCP 0101-0106'!T:T,0)=MATCH('RAS EpSelect 0101-0106'!P2,'RAS HCP 0101-0106'!DG:DG,0)

This will return TRUE if both parts of an exact match are found and are both on the same row.

Is this what you need?

Regards,
Chris