i'll use the column E to do the vlookup
=VLOOKUP(B1,C$1:D$33000,2,0)
and copy the formula for all B.
explanation : find value of B1 in C1:C33000. If found, take the 2nd column
of C1:D33000, so it must be in column D.

If you don't want to get bothered with "#N/A"s, replace the formula
=IF(ISERROR(VLOOKUP(B1,C$1:D$33000,2,0)),"",VLOOKU P(B1,C$1:D$33000,2,0))

"Jeanne" wrote:

the function arguments. Sometimes if I try to answer the function values and
then do f2 I can see what it is trying to do. Can you tell me what would go
in each function argument based on the coumn info I gave?

"Alvin" wrote:

yup..
as far as i know, VLOOKUP is enough for this job.
may i know what really confuses you?

"Jeanne" wrote:

I am using excel 2002. I have two groups of data in one spreadsheet that I
am trying to comare. Here is my example:
Column A = value of a statement cycle, Column B account number, There are
4000 statement cycles and 4000 account numbers.
Column C with 33,000 account numbers, column D = value of 33,000 statement
cycles. In a seperate column I need to compare the two account number
columns, if the number is in both B & C then I need to know what the value is
in D and return that answer. Since there are more account numbers in C than B
I can not seem to make VLOOKUP work, but that function really confuses me.