Hi all,
I have this following table :
<tbody>
</tbody>
I use the following to get the approved km column
=VLOOKUP(B2,KM!$A$2:$G$281,4,0)
Now there are different number of persons in each duty,
like there is one in 6:15 then 2 in 9:15 then 3 in 9:15
and again 4 in 9:15.
(there are multiple entries like this)
Now in a different sheet named 'KM' I have the below table from
where I get the approved KM.
(there are many such locations, I have added only the ones which are in above table)
<tbody>
</tbody>
Here I have to count number of employees and then change the column
number in the formula manually accordingly.
Can any one suggest me a suitable formula
thanks
Jack
I have this following table :
Name | Area | In Time | Approved KM |
xyz | Sinhagad Road | 6:15 | 49 |
abc | Bibewadi | 9:15 | 42 |
def | Sukhsagar Nagar | 9:15 | |
hij | Wakad | 9:15 | 65 |
klm | Pimple Saudagar | 9:15 | |
nop | Aundh | 9:15 | |
qrs | Poud Road | 9:15 | 46 |
tuv | Poud Road | 9:15 | |
wxy | Erandwane | 9:15 | |
ghi | Shukravar Peth | 9:15 |
<tbody>
</tbody>
I use the following to get the approved km column
=VLOOKUP(B2,KM!$A$2:$G$281,4,0)
Now there are different number of persons in each duty,
like there is one in 6:15 then 2 in 9:15 then 3 in 9:15
and again 4 in 9:15.
(there are multiple entries like this)
Now in a different sheet named 'KM' I have the below table from
where I get the approved KM.
(there are many such locations, I have added only the ones which are in above table)
Location | 1 Associate | 2 Associate | 3 Associate | 4 Associate |
BIBWEWADI | 41 | 42 | 43 | 44 |
ERANDWANE | 39 | 40 | 41 | 42 |
Shukravar Peth | 29 | 30 | 31 | 32 |
SUKHSAGAR NAGAR | 41 | 42 | 43 | 44 |
SINHAGAD ROAD | 49 | 50 | 51 | 52 |
POUD ROAD | 44 | 45 | 46 | 47 |
WAKAD | 63 | 64 | 65 | 66 |
Aundh | 46 | 47 | 48 | 49 |
<tbody>
</tbody>
Here I have to count number of employees and then change the column
number in the formula manually accordingly.
Can any one suggest me a suitable formula
thanks
Jack