Thread: LOOKUP Function
View Single Post
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

AC Sales wrote:
I discovered LOOKUP today and it worked fine until I made changes to the
table of data. Now it's returning incorrect figures. Any suggestions?


---------

For LOOKUP() to work properly the data all has to be sorted into order
first. Did you perhaps put an out of sequence value into the table?

Bill