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