Thread: LOOKUP is delivering inaccurate data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default LOOKUP is delivering inaccurate data
"Tom" wrote:
.. The formula is such: =LOOKUP(BG270,BG10:BG$267,B10:B$267)

Believe the lookup vector range: BG10:BG$267
needs to be sorted in ascending order
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote