wildpianist
04-29-2008, 01:21 PM
Hi,
I know this is probably I really easy thing to sort out.
Basically what I want to do is take the numbers from Column A in Sheet A and compare them with Column F in Sheet C. If the numbers match, list them in Column F in Sheet D (which later the sheet will be called "Matched") and if they don't match, then list the numbers that do not match in Column F in Sheet E (later will be called "Unmatched") I'm sure its a simple case of 'IF' commands, but not sure how to use them here.
Hope you guys can help :)
I know this is probably I really easy thing to sort out.
Basically what I want to do is take the numbers from Column A in Sheet A and compare them with Column F in Sheet C. If the numbers match, list them in Column F in Sheet D (which later the sheet will be called "Matched") and if they don't match, then list the numbers that do not match in Column F in Sheet E (later will be called "Unmatched") I'm sure its a simple case of 'IF' commands, but not sure how to use them here.
Hope you guys can help :)