I have a 2 columns of data from oracle, moved to Excel, "Id_Num, Rand_Key"
I have another column that originated on Unix, sent as *.txt, loaded to Excel, "Id_Num_from_Unix"
I'm trying to to VLOOKUP on the Id_Num_from_Unix to the Oracle.Id_Num, but it's not working.
If I compare the two fields, they are different, e.g., =IF(D24=G24,"ok", "Diff !"). But if I subtract the two numbers, I get 0. Visually they're the same.
If I hand type a number, it matches the column from Unix ... so that means the data originating from Oracle is at issue - - - but shouldn't I be able to convert the data type in Excel so things are equivalent? The lengths of the fields are both 6.
I've tried making both columns text, number, general. Can't seem to get the comparison to work.