Excel function

Closed
kadry Posts 2 Registration date Sunday February 10, 2013 Status Member Last seen February 12, 2013 - Feb 10, 2013 at 08:03 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 15, 2013 at 10:11 AM
Hello,

please i need your help in the following problem


I have one worksheet contains many colums, rows, and calculations as follows:

employee id # name basic tax insurane total deduction net
100 mohamed 1000 50 200 250 750
101 ahmed 2000 100 200 300 1700
102 sayed 1500 75 200 275 1225
103 reda 3000 150 200 350 2650
104 fathy 4000 200 200 400 3600
105 baher 2750 125 200 325 2425
i need in another sheet to enter the id number and then get all its related information to be only for each individual or in nother mean for each employee id.

thanks for your consideration and i do appreciate your help

Mohamed Kadry

3 replies

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 11, 2013 at 07:50 AM
Hi Mohamed Kadry,

You can use Excel Vlookup() worksheet function for this. You can read more about Vlookup() worksheet function from here:

http://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx

Please reply if you have any further questions.

Thanks & Regards
Zohaib R
#iworkfordell
0
kadry Posts 2 Registration date Sunday February 10, 2013 Status Member Last seen February 12, 2013
Feb 12, 2013 at 01:50 AM
Hi Zohaib,

Thank you for quick respond, I will try VLOOKUP function and let you know.

Thanks again,

Mohamed Kadry
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 15, 2013 at 10:11 AM
Hi Mohamed Kadry,

Please post the results in the forum so that it helps other users who have a similar excel queries.

Please do write back to us.
0