Hey Excel ninjas. Kinna looked all over for an answer to this and got to the point where registering to a forum seems like the only way.

I have a formula that only seem to work in the first row. Pretty simple "if found then copy" type of formula but still don't work.

Any genius can help me with this?

Thanks tonstest data.xlsx