partial match

I have a table containing a column of names in the form (V1a, V1b, V1c, V2, V3a, V4a, always in that sort of order). Next to this column is another containing number values. I want to sum all the values belonging to the same name (V1, V2 or V3). That is, I want to sum the values beside "V1a"...

Greetings to all from a new user! This is a fantastic forum and site, and I'd like to thank the community and Mr. Excel in advance! OK, here's my issue. I have 2 lists to match: I am trying to match 2 columns of company names, one current customers (15,000), and one a list of industry leaders...

I thought this was a brilliant title for my problem until I searched the board and found that this question has already been answered - but in reference to a different problem. Ah well. I have a column, call it E. I have table, call it Cities. It has a column of, um, cities, but entered in...