Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi Dimensional Lookup
Hi
I would appreciate some help to understand the formula I need to undertake this calculation: In one sheet I have a column of employee names and a row of process codes. Below each process code is a value representing the number of hours that process will take to complete. Each employee has a number of hours assigned against each process. In another sheet within the workbook I have a skills matrix. This consists of a column of employee names and a row of process codes. Each employee has a % assigned to each process. This shows their effectiveness level in that process. The solution I need is for excel to lookup the employee in the skills matrix, match the process code that their hours have been assigned to, read their effectiveness % from the skills matrix and re-calculate the number of hours they have been assigned to that process in line with their skill %. Look forward to hearing from you guys asap as this one has really baffled me. Coolkat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional IF formula using multi-dimensional arrays | Excel Worksheet Functions | |||
2-dimensional lookup | Excel Discussion (Misc queries) | |||
newbie question on multi-dimensional array | New Users to Excel | |||
Two dimensional lookup | Excel Worksheet Functions | |||
Multi-dimensional VLOOKUP / PivotTable ? | Excel Discussion (Misc queries) |