What happened? Take a look at the formula displaying for cell D8. It is:

="LOOKUP"(B8,G8:G10,H8:H10)

That isn't the formula that is in cell D1.

What has happened is that Excel has changed the formula as it copied it.