View Single Post
 
Old 01-29-2015, 12:38 PM
Boyko Boyko is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 8
Boyko is on a distinguished road
Exclamation It looks like a bug in Lookup command

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
File Type: xlsm Test LOOKUP.xlsm (30.8 KB, 12 views)
Reply With Quote