Excel 2003 "VLOOKUP" function
 

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

Excel 2003 "VLOOKUP" function
 

Hello,

How about a simply IF formula?

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


HTH,
JP

On Oct 19, 2:30 pm, Leon wrote:
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

Excel 2003 "VLOOKUP" function
 

We would love to but it would be so much more efficient if you gave a clue
what your data looks like.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Leon" wrote in message
...
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

Excel 2003 "VLOOKUP" function
 

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?

"Bernard Liengme" wrote:

We would love to but it would be so much more efficient if you gave a clue
what your data looks like.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Leon" wrote in message
...
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

Excel 2003 "VLOOKUP" function
 

Sure does. Try:

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

--
Regards,
Fred


"Leon" wrote in message
...
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?

"Bernard Liengme" wrote:

We would love to but it would be so much more efficient if you gave a clue
what your data looks like.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Leon" wrote in message
...
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