Thread: How can "=LOOKUP(I4,I2:I11)" POSSIBLY return #N/A??
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FatBytestard FatBytestard is offline
external usenet poster
  
Posts: 24
Default How can "=LOOKUP(I4,I2:I11)" POSSIBLY return #N/A??
On Sun, 24 May 2009 11:45:01 -0400, Ron Rosenfeld
wrote:

On Sun, 24 May 2009 13:17:26 GMT, Lars-Åke Aspelin
wrote:

FALSE would be a better choice for range_lookup if the values are non
sorted.

/ Lars-Åke

Typo. You are, of course, correct.
--ron


Not. Brain typo maybe. I guess you call that one a bubble sort. :-)
Reply With QuoteReply With Quote