| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I SUM multiple results from a VLOOKUP?
I am using a VLOOKUP to look up the name of an employee and return the hours
they worked on all projects for each day. However an employee is able to work on multiple projects, which causes for multiple entries in the vlookup range. How do I get it to sum these numbers and provide me with one result? Currently it is returning the first result found in the range. I am currently using the following VLOOKUP formula: =VLOOKUP($B14,Mon!$D$4:$Q$100,13,0). Any help is greatly appreciated!! Melissa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Results for Vlookup in one column | Excel Worksheet Functions | |||
| Multiple results in Vlookup | Excel Discussion (Misc queries) | |||
| Looking up multiple results with VLOOKUP | Excel Worksheet Functions | |||
| how to return multiple results in vlookup? | Excel Worksheet Functions | |||
| Add multiple vlookup results | Excel Worksheet Functions | |||
Threaded Mode
