| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct VS Lookups
Dept Acct Hrs
Have columns with 9160 3210 160 9160 3610 80 Worksheet with ALL depts and all accts listed on it. Need to fill it in with just the data that matches dept , acct, hrs. Sumproduct will work, little clumsy for me, is there any way to get Vlooup to look at both coluns on both sheets and pull the hours numbers only when they match up. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct and row lookups | Excel Discussion (Misc queries) | |||
| need help with V lookups | Excel Worksheet Functions | |||
| Lookups | Excel Worksheet Functions | |||
| Lookups | Excel Discussion (Misc queries) | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Threaded Mode
