View Single Post
  #2   Report Post  
swatsp0p
 
Posts: n/a
Default


Did you follow all of the rules for LOOKUP? Is the data in 'EXCEL PRICE
BUILDER'!$B$339:$B$347 sorted in ASCENDING order? If not, it is
possible to return an incorrect value.

from HELP: Important The values in lookup_vector must be placed in
ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise,
LOOKUP may not give the correct value. Uppercase and lowercase text are
equivalent.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=374126