ExcelBanter - LOOKUP Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - LOOKUP Function (https://www.excelbanter.com/excel-discussion-misc-queries/29202-lookup-function.html)

AC Sales

LOOKUP Function

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?

Bill Martin -- (Remove NOSPAM from address)

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

All times are GMT +1. The time now is 11:52 AM.