Perform Following Task

DEAR READERS,


1) FILE 1, SHEET A LOOKS LIKE THIS.

A B C D E F G
EMP# DEPT Sal Bonus1 Bonus 2 Bonus 3 Bonsu 4
ABC-726 MK 40000 9500 1560 2100 1300
LMN-123 MK 21000 3100 4156 3130 7136
XTY-3163 CO 32000 999 1316 2100 1300

SIMILAR KIND OF RECORDS FOR VARIOUS DEPT & VARIOUS EMP # ARE INCLUDED IN THIS SHEET. IN OTHER WORDS ITS THE MASTER FILE WITH DETAIL INFO ABOUT ANY EMP.

2) FILE 2, SHEET A

A B C D E F G
EMP# DEPT Sal Bonus1 Bonus 2 Bonus 3 Bonsu 4


3) I NEED YOUR ASSISTANCE TO RESOLVE THIS PROBLEM, KINDLY HELP.


IF WE INSERT ANY EMP# IN COLUM A OF FILE 2 ON THE SAME FORMAT (AS MENTIONED IN IN FILE 1). IT CHECKS IT FROM FILE 1 AND FILL ALL CORRESPONDING ENTERIES IN FILE 2.


Furthermore, pls note that i already tried various functions i.e. lookup, match etc but unable to achieve the desired results, may be i have some problem in writing the correct syntax.

kindly propose the solution at your earliest.


Regards,

jbman.

Hi,

I have attached a zip file in which there are two files file1.xls and file2.xls. If file2.xls, there are formulas in the range $B$2:$F$2. Kindly check and let me know if this could really help you.


Regards
mtpSuresh