Compare a List

's Computer Specifications

to compare a list of names or numbers... I would always seem to use two
VLOOKUP formulas...

i.e.. find A1 in B:B and find B1 in A:A

does anyone know a better way?

's Computer Specifications

I use =match()

=isnumber(match(a1,b:b,0))

Will return True if there's a match.

David Barnhart wrote:
>
> to compare a list of names or numbers... I would always seem to use two
> VLOOKUP formulas...
>
> i.e.. find A1 in B:B and find B1 in A:A
>
> does anyone know a better way?

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare my list to an existing list	Beep	Microsoft Excel Worksheet Functions	1	18th Dec 2009 06:41 AM
how to compare list	Pascal	Microsoft VB .NET	2	27th Dec 2008 07:10 PM
Compare List A to List B, Return List B Items Not in List A	zwestbrook	Microsoft Excel Programming	4	18th Sep 2008 10:32 PM
Compare List<T>	=?Utf-8?B?Um9u?=	Microsoft C# .NET	1	11th Jul 2006 08:27 PM
compare List A and list B delete the number that occurred more th.	=?Utf-8?B?Y29tcGFyZSBsaXN0IEEgYW5kIGxpc3QgQUI=?=	Microsoft Excel Worksheet Functions	2	14th Sep 2004 04:32 PM