Match two lists and return a value

G

Guest

I have a worksheet with 12000 lines of employee data. At the end of the work
sheet I appended 200 names in the name column. I need a formula that will
match the 200 names with the previous 12000 lines an returen a 1 in the
corresponding/matching row in the A column
 
G

Guest

mdeanda said:
I have a worksheet with 12000 lines of employee data. At the end of the work
sheet I appended 200 names in the name column. I need a formula that will
match the 200 names with the previous 12000 lines an returen a 1 in the
corresponding/matching row in the A column
Click to expand...

Why won't the following IF statement work?
IF(B2=(B12347:B12565),1," ")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Vlookup and return sheet name also 2
I think I need to use Index, Match, and IsNumber but am confused 13
find number in a data base 5
Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B 2
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column o 2
Return value if two data points match 3
Match and Vlookup issue 2

Top