Struggling with Excel? How to Link Data Across Sheets for an Attendance Tracker

Hi, I need some help in Excel. I want to attach two or more cells in two different sheets. For example, while making an attendance sheet, I have two sheets. What I want is when I write any name in the first sheet, it should search for the same in the second sheet and post all the resulting data from the first sheet to the second sheet under the same name in different cells. Kindly help me if possible. Here is my email: [Email Removed For Privacy Reasons].

Possible through the use of VLOOKUP/HLOOKUP function in Excel. For more, please send some sample data.

Regards,
Amitava
[Phone Number Removed For Privacy Reasons]

Thank you for the help, but I think that is not what I want. Or maybe I don't understand how to use it. So here is the sample file for what I want... I hope you can help me.

Regards

Please use HLOOKUP and VLOOKUP to bring the data you want to get in the sheet, as advised by Amitava.

Hi, basically, I am trying to manage employees' Annual Leave Record, and I don't want to compare anything. Instead, I want to save time. For this, when I enter data in sheet1, I want the resulting data to automatically enter in the annual sheet in front of the same month mentioned in sheet1.

For example, if I write "March" in sheet1, the resulting data should automatically enter in front of "March" in the Annual sheet. The annual requirements are only two: Leave Available and remaining leave.

Hope you guys understand.

Regards