formula for distribution of charges

  • Thread starter Thread starter barachiel
  • Start date Start date
B

barachiel

Hi,

Im planning to create a spreadsheet wherein the
distribution charges (col.D,E,F,G) from their salary will
be made upon entry of their employee no.
A B C D E F G
Emp.Name Salary Comp.# Alp Brav Char Delt
3725
16

This is the employee code
Salary Alp Brav Char Delt
Comp# 0-999 1,550 50% 50%
1000-2599 950 20% 40% 30% 10%
3000-4500 750 10% 10% 40% 40%

Emp.Name Comp#
Paul Smith 16
Greg Simon 3258
Joel Tucker 2566

Is it possible for:
1. when the Comp # in column C will be entered column A &
B will appear their respective name & salary?
2. Upon entry of the Comp.#, column D,E,F,G will likewise
be computed and charges will be distributed.

Hope you could help me make this possible.

Thank you in advance.

barachiel
 
Hi
if the employee code is in column A you can use VLOOKUP. e.g. if you
enter the code in C2 use
=VLOOKUP(C2,'Employee_Sheet'!$A$1:$C$,2,0)
to get the employee name

HTH
Frank
 
Mr.Frank,

Thanks for your advised on my question # 2, can you help
me find a solution for my other question (#1)?

barachiel
 
Hi
you can use the VLOOKUP formula for all other columns as well (just
adapt the third parameter). If you like, you can send me an example
sheet (frank[dot]kabel[at]freenet[dot]de) and i'll set-up an example
row for you

Frank
 
Back
Top