string;# Before Values in a SharePoint List’s Lookup Column Based on a Calculated Value

I’ve seen lots of posts discussing this, but no workarounds.  Here’s the situation: One list (List 1) contains a list of values that are calculated (say ColumnC = ColumnA & ColumnB) Another list (List 2) uses ColumnC above as a lookup for one of its columns If you go into Datasheet view for List 2,…