Hi,

Thanks for the reply.

And yes, I want cell D2 to be the formula, through column A, to find the cell value with text from cell B2 and the results should be from coloum A.

But the formula doesnt seem to work when I drag it down.