Forumla issue

[Dan190984]

Hi all

It is early in the morning and I am struggling with a formula I know is basic.

Basically if something in column A on sheet 1 appears in column A on sheet 2 then I want to copy column X (sheet 1) into column X (sheet 2).

How would I do this.

Thanks

 

[prajul89]

I didn't understood what you said exactly but I think Vlookup should help you.