What formula could i use to to find names in a of information? Would using a index and match make more sense than a Vlookup or something Else? I'm trying to say if the information in column A appears in Column C, Appear in Column B
<tbody>
</tbody>
Column A | Column B | Column C | ||||||||||
<tbody> </tbody> | (EXCEL Formula) | Test Agent 1 | ||||||||||
<tbody> </tbody> | schedule | |||||||||||
Test agent 3 | 3/26 | |||||||||||
Test Agent 4 | N/A | |||||||||||
Schedule ad | ||||||||||||
Percent | ||||||||||||
Test Agent 2 | ||||||||||||
Test agent 3 | ||||||||||||
Wednesday |
<tbody>
</tbody>