I have column of entries, each of which has a cell with text
consisting of a few letters, either 'DPA', 'DP', 'ST'
I'd like to make a formula where the text points to a value given in
another cell - a key as it were.
something like =IF(B1='DPA',$X$10)
since I can't get a formula to 'lookup' a key, is there an easier way
of doing this?
thanks
