=IF(ISNA(YourFormula),0,YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"smithers2002" wrote in message
...
Hi Ron,

Have got this sussed now using Vlookup, thanks. You might be able to
answer
me another question though- is there anyway of inserting a 'blank' instead
of
'False' at the end of the statement. Ideally I would like the spreadsheet
to
return blank cells instead of n/a. Would ISERROR work?

Thanks, Lynsey

"Ron Rosenfeld" wrote:

On Thu, 21 Apr 2005 01:43:03 -0700, smithers2002
wrote:

Is there anything you can suggest?

A lookup table was already suggested by several posters, along with a
recommendation to check out VLOOKUP in Help.

Did you try this?

Was there a problem using it?



--ron