How to replace strings in a table with the value of strings from another table? (see attach)

Stuart_Bruff wrote: Neptali Barte wrote: How to replace strings in a table with the value of strings from another table? Then get the sum of the product of the 1st & 2nd col, 3rd & 4th col...etc. (or col1xcol2 + col2+col3 + col4xcol5...etc) Sorry, don't have time to make it more elegant ... just dashing out to work ...

That's odd ... I can't see the worksheet I posted. Just in case, I've whipped up another one ...

Stuart

Message was edited by: Stuart_Bruff Forgot to add, I've only got M13 at work so can't open your original worksheet ... hence making some data up and hoping I remembered the nature of the problem!!!!!