B
bseeley
I have two worksheets in the same workbook. I want to compare two columns
from each sheet, both labeled "Case ID", and if matching ID's are found then
compare another column for the same row labeled "Frequency". If the ID's
match and the frequencies match, then I would want it to return the word
"yes" in a different column (e.g. column F). If the frequencies are
different, then I would want to return the frequency from the first
worksheet. If there isn't a matching ID found, then it would leave the cell
in column F of that row blank.
For example,
Worksheet A Worksheet B
C H C H
Case ID Frequency Case ID Frequency
1596-5218 Monthly 1596-5218 Every 2 Months
1052-1012 Every 6 months 1213-0763 Monthly
0250-2845 Monthly 0250-2845 Every 3 Months
0143-7778 Every 3 months 0931-5110 Every 2 Months
And return to Worksheet A
C F
1596-5218 Yes
1052-1012
0250-2845 Monthly
0143-7778
Please help! Thanks very much
from each sheet, both labeled "Case ID", and if matching ID's are found then
compare another column for the same row labeled "Frequency". If the ID's
match and the frequencies match, then I would want it to return the word
"yes" in a different column (e.g. column F). If the frequencies are
different, then I would want to return the frequency from the first
worksheet. If there isn't a matching ID found, then it would leave the cell
in column F of that row blank.
For example,
Worksheet A Worksheet B
C H C H
Case ID Frequency Case ID Frequency
1596-5218 Monthly 1596-5218 Every 2 Months
1052-1012 Every 6 months 1213-0763 Monthly
0250-2845 Monthly 0250-2845 Every 3 Months
0143-7778 Every 3 months 0931-5110 Every 2 Months
And return to Worksheet A
C F
1596-5218 Yes
1052-1012
0250-2845 Monthly
0143-7778
Please help! Thanks very much