Hi Philippe

i've set up a workbook based on your formula and it works fine for me ...
the only thing i can suggest is that you click on the cell containing the
formula and use tools / formula auditing and evaluate formula to step
through the formula to see where the problem is occuring.

Cheers
JulieD

"Philippe L. Balmanno" wrote in message
news:u2Akd.43572$SW3.34348@fed1read01...
Excel 2002:
Help please, I'm trying to do a double lookup. I have two sheets labeled
"CERS" and "UAS Compound Factor". CERS will have two values to lookup in
the UAS Compound Factor sheet; one a value in a row and the other a value
in a column. The problem is that the formula returns an #N/A error when
there is a value in the cell that is cross referenced.

I'm using a formula similar to Chip Pearsons example at:
http://www.cpearson.com/excel/lookups.htm

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

UAS Compound Factor'!A5 = n -- Base Cell
CERS!L53 = 54 -- n value to look up
UAS Compound Factor'!A6:A105,0 -- brings back cell A59 where 54 is found
CERS!L54 = 1.5% -- i value to lookup
'UAS Compound Factor'!B5:AL5,0 -- brings back cell D5 where 1.5% is found

The expected value should be the intersection of A59 and D5 which is
82.295 instead I get a #N/A.

UAS Compound Factor = Uniformed Annual Series Compound Factor =
[(1+i)n-1]/i

Thanks in advance,