Excel 2003 "VLOOKUP" function

[Guest]

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

 

[JP]

Hello,

How about a simply IF formula?

=IF(A1=B1,"1","0")


HTH,
JP

 

[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

 

[Guest]

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?

 

[Fred Smith]

Sure does. Try:

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