Search : in
By :

Use Vlookup to match data in two seperate she

Last answer on Jul 2, 2009 6:18:58 am BST Rus, on Jul 1, 2009 1:24:45 pm BST 
 Report this message to moderators

Hello,

I was wondering if you guys could help me out with all of your excel knowledge. I have compiled a big database in two seperate sheets with mostly the same information. I need to see if the numbers match in both sheets and if they do not match I would like them to be highlighted red. This is to see where there are discrepencies in my data. Now the rows are not in the exact same order but the data in the colums should be the same.

How can I do this. I assume I would use a vlookup? Any help would be greatly appreciated.

Thanks.

Configuration: Windows XP Internet Explorer 6.0/ Excel 2007

Best answers for « Use Vlookup to match data in two seperate she » in :
How to split data into multiple worksheets? ShowHow to split data into multiple worksheets? Issue Solution Note Issue I hope someone can help! I have a .csv file open with excel that contains a large amount of data that has been merged together so that each data set follows each...
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
[Vista] Unable to install Service Pack 2 Show[Vista] Unable to install Service Pack 2 You try to install Service Pack 2 (SP2) for Vista and you get an error (0x80070057), here's the solution: Uninstall the 3 latest security updates following: KB970653 KB972036 KB973874...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
PS/2 connector ShowPS/2 connector The PS/2 connector (mini-DIN6 format) is mainly used to connect computers to keyboards and mice. Pins Pin number Function 1 Clock 2 Ground 3 Data 4 Ground (or not...
EDGE (Enhanced Data Rates for GSM Evolution) ShowIntroduction to the EDGE standard The EDGE (Enhanced Data Rates for GSM Evolution.) standard is an evolution of the GSM standard that modifies the type of modulation. Like the GPRS standard, the EDGE standard is intended to be a transition to third...
Ask your question Reply

1

venkat1926, on Jul 2, 2009 1:35:13 am BST
  • +1

Quote
f the numbers match in both sheets
unquote

which cells in the two sheets. some more classifications are required in your query

   
Reply to venkat1926

2

 mubashir aziz, on Jul 2, 2009 6:18:58 am BST
  • +2

Suppose you have two sheets Sheet 1 and Sheet 2 now you want to hight light the cells in sheet 1 which are not in sheet 2 ...........

1. Select the range of column in sheet 2 and give then a name suppose data is in A column now select the A1:A100 and by using inert > range > now give the name my_range_sheet_2

2. now select the cells from A1:A100 in sheet 1 and go in Format>conditional formatting > Select Formula is in Condition 1 and paste this formula =ISERROR(MATCH(A1,my_range_sheet_2,0)) and format the back ground as red

All the values which are not in sheet 2 will be highlighted .....

you can repeat the same for sheet 2 as well ........






Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help