Use the excel function VLOOKUP ____,,,,_{=F4=BF=F4}_,,,,_____ Thanks & Regards Rajesh V -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On = Behalf Of Carolyn Peat Sent: Wednesday, June 07, 2006 01:05AM To: mso@xxxxxxxxxxxxx Subject: [mso] Excel Query Hello Could someone please give me some advice. I have a large spreadsheet whith a column of ID numbers. I have copied another column of numbers to this sheet and now I want to match the identical numbers in the first column with the second. Is there a quick = and easy way to do this. Thanks Carolyn ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx = or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your = email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, = send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an = invitation with instructions. Once you are a member of the files group, you can = go here to upload/download files: http://www.smartgroups.com/vault/msofiles If you are using Outlook and you see a lot of unnecessary code in your = email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ________________________________________________________________________= ___ 'Visit us at www.sundaramfinance.in ' ________________________________________________________________________= ___ "This E-mail may contain privileged information and is intended solely = for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by = mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of = SUNDARAM FINANCE LIMITED. As per SUNDARAM FINANCE LIMITED's policy, unencrypted = mail via Internet is not considered secure". ________________________________________________________________________= ___ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************