LOOKUP Function

A

AC Sales

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?
 
G

Guest

AC said:
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?
Click to expand...

---------

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
 
Top