Please look at the Tables 1.X and Tables 2.X in the attachment.

The formulas in Tables X.1 are absolutely identical and created via copy & past by formula&format. The surprise is that the LOOKUP command in Table 1.1 cannot locate the correct (sR/s0) coordinate from Table 1.0 in the first column of the table while in any other columns in Table 1.1 or Table 2.1 the same command is OK.

Does someone know what is the reason for LOOKUP to behave differently in these two examples. I did various of test and I did not find the reason.



Thank you very much in advance

Attached Files

Test LOOKUP.xlsm (30.8 KB, 12 views)