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