Text Matching in Excel

[yohan.matale]

I have 2 tables



1) where one is having a column ; name of the student with registration no. (Registration)

2) Other table has attendance with only registration no (Attendance table)



Student table consists name and registration no whereas attendance has only registration no only.

I do want to match two tables, who has attended and the date of registration.

How can i do that, any excel function.

Grateful if someone could help me.

 

[Pavan Kumar Sistla]

Hello Yohan,

Attached is the excel file for your reference. I have tweaked your formula to work for the purpose.

Please check and let me know if you have any questions.

Regards,
Pavan.

 

[yohan.matale]

Hello Yohan,

Attached is the excel file for your reference. I have tweaked your formula to work for the purpose.

Please check and let me know if you have any questions.

Regards,
Pavan.

It works well.

Many thanks Pavan, really appreciate the assistance. In case I come across difficulty,,i will get back to you.

Thanks again.