Use with Calculated Columns

Jan 22, 2009 at 2:47 PM
i want to be able use the information entered in the lookup field in a calcualted column. However when i attempt to do so it does not show up in the list of available columns, if i manually enter the column name in the formula like =[Column1], i get "One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas." i'm not sure if it is even possible to allow this with custom columns but it would be great if we could use it with calculated columns.
Jan 24, 2009 at 2:01 AM
I would be interested to know feasibility of calculated columns in lookup as well. Not sure if such time investment would pay off though.