Click anywhere on the sheet to deselect the pasted data... oops, looks like we have a problem again. The formulas were pasted, rather than the numbers. But the lookup tables don't exist on this worksheet, so the formulas are just returning #N/A.