Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cell Range Comparison in Excel 2007

Posted on 2011-02-22
3
Medium Priority
?
326 Views
Last Modified: 2012-05-11
I have 2 cell ranges that I need to compare and return a list of values that have have no match.
VLOOKUP?

A    
6335                      
6409
6409
6427
6458
6458


B
6335
6409
6427
6458
6459
6463
6465
6469
6542
6554
6557
6568
0
Comment
Question by:psueoc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Tracy earned 2000 total points
ID: 34952006
Yes, you can use Vlookup.

So if your A set above is in Sheet 1 starting at A1, add the vlookup below to column B in the corresponding row.  This will look up your B dataset above, assuming it's in Sheet2 starting at A1.

=Vlookup(A1,'Sheet2'!$A$1:$A$12,1,False)

See attached.
Book1.xls
0
 
LVL 24

Expert Comment

by:Tracy
ID: 34952110
Alternatively, you can use a combination of the Index/Match function.

=INDEX($A$1:$A$6,MATCH(A1,Sheet2!$A$1:$A$12,FALSE),1)
Book1.xls
0
 

Author Closing Comment

by:psueoc
ID: 34952211
great solution thanks
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question