Excel function

[Closed]
Report
Posts
2
Registration date
Sunday February 10, 2013
Status
Member
Last seen
February 12, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
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
Posts
2
Registration date
Sunday February 10, 2013
Status
Member
Last seen
February 12, 2013

Hi Zohaib,

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

Thanks again,

Mohamed Kadry
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
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.