Please Help - Cpmparing multiple sheets

[Marmalade]

:x

Good Afternoon,

I have a workbook with 2 sheets containing data. I need to compare the 2 sheets and extract exact matches.

The 1st sheet is called Chris HQ and the data resides in column G3:G397 and the second (which is where I need to report the matches) is Chris Out column A2:A234.

Please can anyone help or I will be forced to check each one via Autofilter!

Thanks

M

 

[Greg Truby]

• Have a look at the VLOOKUP function. See the Wiki entry for more info. Play with that a bit and search here, there are many, many posts on this theme. Still stuck? Post back in the main forum
• The "International" forum is not about where you are from, it's about your preferred language; i.e. non-English posts go here, English posts go in the main forum.

{edit}I see you have already posted in the main forum. Please do not post the same question in multiple forums. I will ask a moderator to lock this one so that any discussion will take place on the thread in the main forum. ( http://www.mrexcel.com/board2/viewtopic.php?t=184116 )

Regards,