Hi,

I have text in columns A, B and C. I am trying to create a formula in column D that will, for each item in C, return the first item in column B that is on the same row or on a row above it.

For example, consider C11. In D11 I would like a formula to return the first text it encounters when looking up column B from B11 to B1.

Can someone please suggest a solution.

Thanks!