formula for distribution of charges

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

barachiel wrote:
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

Mr.Frank,

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

barachiel



-----Original Message-----
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

barachiel wrote:
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
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

barachiel wrote:
Mr.Frank,

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

barachiel



-----Original Message-----
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

barachiel wrote:
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


.