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

 

[NARAYANK991]

Hi Sajnani ,


Can you confirm this ?


If a patient has a unique ID , how many times can this ID appear in either of the two sheets ? Will it appear only once , or can it appear multiple times ?


In which sheet will it appear only once , and in which sheet can it appear multiple times ?


Narayan