Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match two lists and return a value
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using formula to compare two text lists that are not alike and ma. | Excel Worksheet Functions | |||
How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
How do I return dynamic lists? | Excel Worksheet Functions | |||
How to compare 2 lists and return un-matched? | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |