Deb G wrote:
I think that somehow an underlying setting in Excel was interpreting the base
file as not being in ascending order. Curiously, the next day the problem
went away, and it hasn't come back. FYI, here was one of the Lookup formulas:

=LOOKUP($A5,'M:\Finished_Goods_Kanbans\[PullItemStatus.xls]PullItemStatus'!$A:$A,'M:\Finished_Goods_Kanbans\[PullItemStatus.xls]PullItemStatus'!$K:$K)

where $A5 is the item ID.

Thanks,
Deb


If an item ID is not in ...!$A:$A, you'll fetch a wrong value, in case
the value in ...!$A:$A is lexically or otherwise smaller than A5 is not
admissible. The remedy would be:

=IF(LOOKUP($A5,x!$A:$A)=$A5,LOOKUP($A5,x!$A:$A,x!$ K:$K)

Substitute
'M:\Finished_Goods_Kanbans\[PullItemStatus.xls]PullItemStatus' for x,
which I used as an abbreviation.