Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2013, 12:27 PM
duskdjl duskdjl is offline Excel - search Multiple Values (HELP!) Windows 7 64bit Excel - search Multiple Values (HELP!) Office 2010 64bit
Novice
Excel - search Multiple Values (HELP!)
 
Join Date: Mar 2013
Posts: 2
duskdjl is on a distinguished road
Default Excel - search Multiple Values (HELP!)

Hi,

I need the help of a guru. I'm an intermediate (NOT ADVANCED) user tasked with an assignment and I'm not sure of the best way to execute the idea. I have two spreadsheets FILLED with data. I have to take Manufacturer numbers from a column in one spreadsheet, and compare them to the the manufacturer numbers in a similar column of another spreadsheet to find matches. There are thousands of numbers! What is the best and quickest way to do this?! I would love to open List B and run a check for all the numbers from List A at the same time. Hope I'm making sense because I need a savior.

Please answer my question (in a user-friendly, step by step fashion if you would) and consider your good deed for the day done!



Thanks,

*Overwhelmed*
Reply With Quote
  #2  
Old 03-27-2013, 07:38 AM
ArviL ArviL is offline Excel - search Multiple Values (HELP!) Windows 7 64bit Excel - search Multiple Values (HELP!) Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

Hi

P.e. you have manufacturer numbers on Sheet1 in range Sheet1!A2:A1000, and on Sheet2 in range Sheet2!C2:C99.

You enter p.e. into cell Sheet1!X2 the formula
=ISERROR(VLOOKUP($A2,Sheet2!$C$2:$C$99,1,0))
and then you copy it to range Sheet1!X2:X1000. Manufacturer numbers in rows where the formula returns FALSE are missing from Sheet2.

In similar way, you enter p.e. into cell Sheet2!X2 the formula
=ISERROR(VLOOKUP($C2,Sheet1!$A$2:$A$1000,1,0))
and then you copy it to range Sheet2!X2:X99. Manufacturer numbers in rows where the formula returns FALSE are missing from Sheet1.
Reply With Quote
  #3  
Old 03-27-2013, 08:47 AM
duskdjl duskdjl is offline Excel - search Multiple Values (HELP!) Windows 7 64bit Excel - search Multiple Values (HELP!) Office 2010 64bit
Novice
Excel - search Multiple Values (HELP!)
 
Join Date: Mar 2013
Posts: 2
duskdjl is on a distinguished road
Default Thanks

Thank you Arvil. I'll try it...but first I need to know what p.e. stands for Sorry
Reply With Quote
  #4  
Old 03-28-2013, 01:11 AM
ArviL ArviL is offline Excel - search Multiple Values (HELP!) Windows 7 64bit Excel - search Multiple Values (HELP!) Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

Quote:
Originally Posted by duskdjl View Post
Thank you Arvil. I'll try it...but first I need to know what p.e. stands for Sorry
Per example
Reply With Quote
  #5  
Old 03-27-2013, 10:29 AM
Kevin@Radstock Kevin@Radstock is offline Excel - search Multiple Values (HELP!) Windows 7 32bit Excel - search Multiple Values (HELP!) Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi duskdjl

Probably easier if I attach the file. These are array formulas, CTRL + SHIFT + ENTER
These will list the values that are in one list but not the other, see if this is of any use!

Kevin
Attached Files
File Type: xlsx 003-Lists.xlsx (16.6 KB, 19 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
search on multiple word documents Guy Roth Word 7 03-06-2017 01:31 PM
Excel - search Multiple Values (HELP!) Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
Excel - search Multiple Values (HELP!) Find, aka search aka ctrl+pgdn across multiple lines snarfii Word 1 04-22-2012 09:56 PM
Excel - search Multiple Values (HELP!) How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Excel - search Multiple Values (HELP!) Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft