Hello guys,
i'm quite fresh with all this excel coding.
I've got two sheets, in one of them there are 3 colums, that contains customers name and it's reference number, in the second sheet i've got customers names and reference numbers and post codes plus more info that i don't need.
i need to pull the post codes to sheet one from sheet two.
In the picture uploaded i need the data from left picture (lets call it sheet 1, to go to right picture colum D, that's on a sheet 2.)
In my head the formula should look at the
Ref columns on both sheets and if
Ref matches it should pull data from P(D) column on Sheet 1 and move it to Sheet 2 column P(D).
Is it possible to do so?
Thanks.