more cell matching fomulars please

[tonylpcs@yahoo.co.uk]

Hi Everyone,

Ok this one is slightly differnet but hope you can help me again

I Have Colums A,B,C,D,

A And C might contian the same names but not on the same rows,
i need to if any data in row A matches the data in the cell im in in row D then row C needs to have that same information,

so i need a formula to put in Colum D that will do the following.

lets say im starting in cell D2 the forumlar needs to do this:

if data in cell C2 = any cell in Colum A then the data in Colum B of that same row as the matching colum A data is copied to cell D2.

please can someone help.

thanks

Tony

 

[tonylpcs@yahoo.co.uk]

please help?