Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two way lookup
Sir,
I have two files one is payroll and other is advmaster in adv master data is like this emp name emp no. adv jan feb mar apr may......dec jack k-123 5000 500 500 650 400 jill k-124 2000 100 100 100 in the payroll file month : jan emp name emp no pay ot total adv ded net jack k-123 15000 15000 jill k-124 10000 10000 In the adv coloum i want a formula which should match the emp no of emp in payroll and emp no of emp in adv master and parallely it should check the month of payroll with month of adv master and to take that value to deduct. can any one help me in this regards srinivas -- srinivas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |