vlookup or index formula

[bigmacneb]

Hello, I have two worksheets. In the first sheet I have a list of numbers (750 rows) in the second worksheeet I have data in column 6 that might match the numbers in Sheet 1. I need to compare all of the numbers in Column 6 to Sheet1 and if there is a match I need it to put the number 1 in column 1.
For example, on sheet 1 is the number 1234. On Sheet 2 in Column 6 there are three instances of 1234. For these three instances, I need to insert the number 1 into column 1 for the row of each instance.
Any help is greatly appreciated.
Thanks!

 

[schielrn]

Maybe you want something like this:

=if(isnumber(match(Sheet2!F2,Sheet1!A:A,0)),1,0)

This formula goes in column 1.

Hope that helps.

 

[bigmacneb]

perfect. thank you!