Splitting words in a column and giving them values with vlookup, is this possible?

[Bob_ipc]

I have a filtered list for expenses (LOA, Travel, Truck) each expense has a different value for a different employee, How can I come up with a subtotal in a separate cell?

Total Expenses =$ ??


[TABLE="width: 210"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Personnel Expenses[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]LOA[/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD]LOA, Travel, Truck[/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD]LOA, Travel, Truck[/TD]
[/TR]
[TR]
[TD]Name 3[/TD]
[TD]LOA, Travel, Truck[/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]LOA, Travel, Truck[/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD]Travel[/TD]
[/TR]
[TR]
[TD]Name 5[/TD]
[TD]Truck
[/TD]
[/TR]
</tbody>[/TABLE]

 

[virpericulosus]

I'm not sure I understand. Where are the numbers you want to total?

 

[Bob_ipc]

Oh sorry each expense has a value, different value for different employees, that data is on a table in a different tab. the other table has the info in separate columns and the data I'm trying
to get the totals on has LOA, Truck, and Travel all in the same column separated by a comma. I hope that is somewhat explained?



[TABLE="width: 257"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Names[/TD]
[TD]LOA[/TD]
[TD]Travel[/TD]
[TD]Truck[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 3[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[virpericulosus]

Does using text to columns to split up the comma delimited values help? You want to total 100,100,100 in one cell?

 

[Bob_ipc]

yes that is right, and I'm am actually trying to split columns right now.