Please help me! I need to get the how much will be the contribution of EMPLOYER AND EMPLOYEE depending on his/her salary. Thank you please kindly help me.
Please help me! I need to get the how much will be the contribution of EMPLOYER AND EMPLOYEE depending on his/her salary. Thank you please kindly help me.
Please help!
Hello and Welcome to the forum
copy paste below in C2
=INDEX(D$8:D$20,MATCH($B2,$B$8:$B$20))
drag down and drag to right
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hi
Paste this formula to c2 cell and drag to right and down
=VLOOKUP($B2,$B$8:$E$20,MATCH(C$1,$B$7:$E$7,0))
To Unite both criterias (employee and employer) I changed column names to original
Appreciate the help? CLICK *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks