Lookup

U

Utsav

Board Regular
Joined
Jun 1, 2006
Messages
170
Hi I am having a bit trouble, i want the increment without adding any column....

In one table i am having

desigination increment
clerk 10%
workker 15%
manger 20%
gm 30%
security 10%


In second table

Emp Name Designation
Ram-I Clerk
Mohan Worker
Rajinder Manager
Surender G M
Madan Security
Gaurav Clerk
Harish Worker
Manish Manager
Zaved Manager
Ram-II Manager

In third table

Emp Name Salary
Zaved 10,000
Surender 13500
Ram-II 15470
Ram-I 34256
Rajinder 10000
Mohan 10000
Manish 10,000
Madan 12000
Harish 9000
Gaurav 7500


Now i want

Emp Name Increment
Ram-I
Mohan
Rajinder
Surender
Madan
Gaurav
Harish
Manish
Zaved
Ram-II


Now i want the increment without adding any column I want the increment of a person depending upon his desingation ...

Plz help

Utsav

 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
Hi

I would suggest you take a look at Edit, Paste Special... then use the Multiply operation

HTH

John
 
Upvote 0
You need to correct your spelling mistakes in table one for any suggestion to work. Change "workker" to "worker", and "gm" to "G M".

Now, this formula will do what you want:
=INDEX(Table1Inc,MATCH(INDEX(Table2Desig,MATCH(EmpNameCell,Table2Emp,0)),Table1Desig,0))*INDEX(Table3Salary,MATCH(EmpNameCell,Table3Emp,0))

where I have used named ranges for the parts of various tables, and EmpNameCell instead of the cell reference that contains the employee name to search for.
 
Upvote 0
Hello,

Try

=VLOOKUP(VLOOKUP(L1,$D$2:$E$11,2,0),$A$2:$B$6,2,0)

where D2:E11 is table 2

A2:B6 is table 1

and L1:L10 is list of names
 
Upvote 0
Another spelling mistake .... "manger" to "manager"!!!!
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,216,077
Messages
6,128,685
Members
449,463
Latest member
Jojomen56

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top