VLookup Elimination Lookups

[californialove]

Hi, I was just wondering if I could get help on something.

I have three big long lists. One is 2003, 2004, 2005.

There is some overlap in the lists, and I want to find 2004's variables that are not in 2003.

how would I make a vlookup for 2004's numbers, excluding the ones that are mentioned in 2003?

Can someone just show me a general construct of a formula?

say there are 400 movie titles in 2004, and I want to look up the movie titles that are new for 2004, so are not in the 2003 list.

I have no idea how to express "lookup value not in 2003 array"

thank you sooooooooooooooooo much if anyone can help me!!!

[Bryan Hessey]

Hi, I was just wondering if I could get help on something.

I have three big long lists. One is 2003, 2004, 2005.

There is some overlap in the lists, and I want to find 2004's variables that are not in 2003.

how would I make a vlookup for 2004's numbers, excluding the ones that are mentioned in 2003?

Can someone just show me a general construct of a formula?

say there are 400 movie titles in 2004, and I want to look up the movie titles that are new for 2004, so are not in the 2003 list.

I have no idea how to express "lookup value not in 2003 array"

thank you sooooooooooooooooo much if anyone can help me!!!

Are your lists in separate columns, or on separate sheets?

=VLookup(A1,B:B,1,False)

will check if the item in A1 appears in column B

=If(IsError(VLookup(A1,B:B,1,False)),A1,"")

will list those that are not.

=VLookup(A1,Sheet2004!A:A,1,False)

will list the items found in another sheet.

Are you familiar with Formula Fill? if not, then see http://www.mvps.org/dmcritchie/excel/fillhand.htm

hth
---

[californialove]

^ damm there's an ISERROR function too?

holy crap, that worked great.

thank u so much *bows*