formula for distribution of charges

[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

 

[Frank Kabel]

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]

Mr.Frank,

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

barachiel

 

[Frank Kabel]

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