Use Vlookup to match data in two seperate she
Closed
Rus
-
Jul 1, 2009 at 08:24 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:18 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:18 AM
Related:
- Use Vlookup to match data in two seperate she
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Display two columns in data validation list but return only one - Guide
- Music match jukebox - Download - Audio playback
2 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
Jul 2, 2009 at 01:18 AM
Jul 2, 2009 at 01:18 AM
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 ........
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 ........
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 1, 2009 at 08:35 PM
Jul 1, 2009 at 08:35 PM
quote
f the numbers match in both sheets
unquote
which cells in the two sheets. some more classifications are required in your query
f the numbers match in both sheets
unquote
which cells in the two sheets. some more classifications are required in your query
