PDA

View Full Version : Solved: Compare Values from two sheets



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 :)

Oorang
04-29-2008, 08:07 PM
Hi WP,
Could you see if this will meet your needs? http://vbaexpress.com/kb/getarticle.php?kb_id=966

wildpianist
05-01-2008, 01:19 PM
Thanks Oorang! In the end I used =IF(ISNUMBER(MATCH etc etc. :)

Oorang
05-01-2008, 09:55 PM
lol That works too :)