I think the data and the formula would help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mandy Brookes" <Mandy wrote in message
...
We have a file which is updated monthly containing 'Vllookups' combined
with
'IF, ISNA' formulae. This has worked successfully for many months but
suddenly will not return correct vlaues for a couple of entries. Nothing
has
changed within the spreadsheet, except the file name. Can anyone shed any
light on this?