Lookup
I created a lookup formula - LOOKUP(C:C,'UPIN INDEX'!A:A,'UPIN INDEX'!B:B),
the formula works as desired, except when the number being looked up doesn't
exist it doesn't come back with FALSE, it fills the blank with the number and
name just preceding. How do I change this?
|