Some thoughts ..

J=Is suppose to be the total weight
and is to read Vlookup(D8,Frate,3,False)

In J8: =VLOOKUP(D8,Frate,3,FALSE)
seems to return correctly when tested here.

But since the vlookup's looking for an exact match (FALSE), there could be
problems if the underlying value in D8 (calculated?) doesn't really match
the lookup values in Frate's 1st col (eg: a calculated value of say, 0.4099
won't be equal to 0.41, although it looks like 0.41 if the cell is formatted
to 2 dp)

Think you could try using TRUE instead in J8:
=VLOOKUP(D8,Frate,3,TRUE)
since the lookup col's values in Frate are in ascending order

Or, alternatively, try something like this in J8:
=VLOOKUP(ROUND(D8,2),Frate,3,FALSE)
which rounds the calculated value in D8 to 2 dp

As for:
P=Vlookup(O8,Drate,3,False),
which is also returning a #NA, but should read Ounce.
&
V=Vlookup(O8,Drate,3,False),
which is also returning a #NA, but should read Ounce.

You're getting #N/A errors for the above simply because the vlookup's table
array: Drate is no longer valid for the lookup value in O8. The actual
lookup col (for O8) is col F in Rate, but Drate's 1st col (the vlookup col)
is col E. So naturally, the #N/As.

One quick fix is to define a new range,
eg: Drate1 =Rate!$F$1:$G$52 (ie with the 1st col = col F),
then you could use in both P8 and V8:
=VLOOKUP(O8,Drate1,2,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---