| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell value with multiple values to vlookup
I have one spreadsheet with the a column with a location code and another
column with the number of employees (Colum A2:A200 are the codes and B2:B200 are the number of employees). On another spreadsheet, some locations are combined into one sigle row. So I have a cell with the location codes separated by a coma (example: A2 = 100, 200). Is there a way for me to use a function on B2 similar to a vlookup that will look both values from A2 and add them up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| returning multiple cell values from a vlookup | Excel Worksheet Functions | |||
| Vlookup multiple values | Excel Worksheet Functions | |||
| combine multiple values in a table into one cell using vlookup? | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
Threaded Mode
