Excel Help - Xls Download

hi i need some help in excel.
i want to attach 2 or more cells in 2 different sheets. for example
while making a attendance sheet i have two sheets and what i want is when i write any name in 1st sheet it search the same in 2nd sheet and post all the resulted data from 1st sheet to 2nd sheet under the same name in different cells.
kindly help me if possible .
here is my e.mail
goldeneyes20006@yahoo.com

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

Dear amitavamaj
thanks for the help but i think that is not what i want or may be i don't understand how to use it. so here is the sample file for what i want .... i hope u can help me.
goldeneyes20006 on yahoo

Sorry,
Your question is not clear; there are no numerical data in Q4:Q17 in your sheet 2. How can you compare oranges and apples?
Have a nice day
Simhan
Leaning and Teaching Fellow (Retd)
The University of Bolton, UK
Chief Advisor, Promentor-consulting

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

Hi
basically am trying to manage employees Annual Leave Record and I dint want to compare anything but infect I want to save time.For this I want when I enter data in sheet1, resulted data automatically enter in annual sheet in front of the same month which I mention in sheet1.
for example
if i write March in sheet1 the resulted data automatically enter in-front of March in Annual sheet. annual requirement are only two Leave Avail and renaming leave.
Hope u guys understand.
Regards

Dear Saima,
Please refer the below provided link:
https://www.citehr.com/397346-excel-...ormulae-2.html