Hello All

I am using excel 2007,on the attached worksheet I have 3 cols of data in cols L,O,Q the values of which will determine the numerical values in cols AX & AY.eg If L5 = LST & O5 = 1 & Q = CHS then AX5 & AY5 will have

values of 101 & 148 respectively.Is it possible to use a formula or macro to produce the values in AX & AY.The

rows can be over 500 long.I have left an empty row between data types for illustration only,there are no empty rows in the data.

Many thanks for help given.

## Bookmarks