Hi all,

on my spreadsheet - R12 on DRG 1sheet it gives a length of 9850. This
gets the information from cell G66 on Quote PG 1, which in turn gets it
from the Lookup on Price Builder AG 342- which has value of 8650. The
values are not the same?

Why?

Checked the Lookup formula, it is correct, no typo's etc.
LOOKUP(I30,'EXCEL PRICE BUILDER'!$B$339:$B$347,'EXCEL PRICE
BUILDER'!$AG$339:$AG$347)

The result_vector part is a formula in itself, - SUM(ab342:af342) from
another worksheet.

This does not happen all the time - any ideas anyone?


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