"Philippe L. Balmanno" wrote
....
The error is in the column value. It was a product of a formula
=1.25%+.25%=1.5%. The Offset Match formula doesn't like looking for the
product of a formula but rather a value because it determined that this
product can change if another factor is changed. Once I entered 1.5% in
the
cell my Offset formula worked.

Think it's because the MATCH() with "zero" as match type
is looking for an exact match. As the lookup value is a product of
a formula, the calculated value may not exactly match
that in the lookup col/row.

Try using ROUND() on the lookup value to improve matching,
viz.: use ROUND(CERS!L53,4) and ROUND(CERS!L54,4)

So this might work:

=OFFSET('UAS Compound Factor'!A5,MATCH(ROUND(CERS!L53,4),'UAS Compound
Factor'!A6:A105,0),MATCH(ROUND(CERS!L54,4),'UAS Compound Factor'!B5:AL5,0))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----