#1
|
|||
|
|||
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* |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Thanks
Thank you Arvil. I'll try it...but first I need to know what p.e. stands for Sorry
|
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Per example
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
search on multiple word documents | Guy Roth | Word | 7 | 03-06-2017 01:31 PM |
Search with multiple strings | silverspr | Excel | 7 | 03-03-2013 04:45 PM |
Find, aka search aka ctrl+pgdn across multiple lines | snarfii | Word | 1 | 04-22-2012 09:56 PM |
How to count multiple values in a single cell, except zero? | iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Sum & difference between multiple values in a single cell | iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |