Hi

How many two letter combinations are there?
Does the cell in column B always contain 3 sets of letters, or, can
there be 1, 2, 3 (or more) sets?

I would be inclined (subject to the answers to the above) to create a
further series of entries in IU and IV
ah zy 5.9
zy ah 5.9
ah pd 3.6
pd ah 3.6
ah zy pd 7.3
plus all the other combinations

Then use
=VLOOKUP(B1,IU:IV,2,0)

--
Regards

Roger Govier


"Terranoman" wrote in message
...
I am attempting to set up a spreadsheet whereby I can summarise the
weight
load of a vehicle. The cells will contain a variation of abbreviated
texts
in the same cell e.g.

An example of column B contents is ah, zy, pd, (in a single cell on
each row)

Each abbreviation will have it's own unique number (weight) allocated
in two
seperate column which the formula will refer to - i.e

Column IU IV
Row 1 ah 2.2
Row 2 zy 3.7
Row 3 pd 1.4

There will be approximately 50 such text references and values.

Currently column b (rows 1 to 50) contain the varied text (ah, zy, pd
etc in
a single cell). Is it possible to 'find' the idividual text
abbreviation
(ah, zy or pd) in column B and total the allocated weight using sumif
or
sumproduct even though they are in the same cell?

Any suggestions greatly appreciated.