Analysis Services returns it's values as text even if it's a number. You usually wont notice as it gets implicitly converted during most operations - however not in a Lookup.

Try converting your lookup value to a string e.g.

=Lookup(CStr(Fields!Col1.Value), Fields!Col1.Value, Fields!Col2.Value, "DataSet2")