"Regnab" wrote:
.. Originally,
I used HLOOKUP as part of the formula but it was inconsistent. It would
work for a while, and then randomly (usually when I changed the value
in another cell - an unrelated one), it would go blank. I would then
have to go and delete the formula and then press undo and hey presto,
it was back to working.

Just a thought on the part above ..
is your book calc mode set to automatic ?
(or it may be inadvertently set to manual calc mode)

To quickly check / change calc mode:
Click Tools Options Calculation tab
Check Automatic OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---