In spreadsheet A I enter a part number. I then have a formula that does a
look up of that part number in spreadsheet B and returns the description,
cost and price of the part number back into spreadsheet A.

This has been working perfectly until today. I found an error with a part
number in spreadsheet B and corrected the error (changed from ":CFF-8" to
"CFF-8"). I have done corrections in the past and added items to spreadsheet
B with no problems.

However, today after correcting the part number in spreadsheet B, all I get
in spreadsheet A for description, cost or price is "#N/A". If I change the
part number back to the old one, then everything works fine. Even if I
insert a new line with the correct part number, it still will not return any
information.

Any ideas what is going on?

Thanks in advance for any help.