Excel 2003 "VLOOKUP" function

L

Leon

Can anyone help me with using this feature. I am trying to compare data in
one column to data in another and place a 1 in another column to sort by
later. Thanks
 
B

Bernard Liengme

We would love to but it would be so much more efficient if you gave a clue
what your data looks like.
best wishes
 
L

Leon

In columns A through J we have numerical and text data. Column A basically
assigned a sequential number to each record beginning with 1 through 4230.
I have a list of 632 records that I want to identify by the number listed in
Column A. When each record is found by VLOOKUP, I want the number 1 placed
in separate column in the record to indicate that it matched one of the 632
numbers listed. Does this help?
 
F

Fred Smith

Sure does. Try:

=if(isna(vlookup(whereverlistof632is,A:A,1,false)),"not there",1)
 
Top