formula to auto fill columns from columns in other tabs

is there a formula that i can put into column A in tab one so it will always fill with info from a different column from a different tab ?

thanks in advance

in SHEET1 A2

=SHEET2!D2

Or do you need something "dynamic" based on other data in Sheet1?

A sample file (not image) showing required outcome(s) will help.

hi john

sorry for late late reply

I have attached a simple version of what I would like help on
I hope it makes sense

I do require something more dynamic , as using that method you said I get loads of 0 when nothing is in the original column

See attached:

In J2

=IFERROR(INDEX(me2w!$B$2:$B$100,MATCH($E2,me2w!$F$2:$F$100,0)),"")

in K2

=IFERROR(INDEX(me2w!$N$2:$N$100,MATCH($E2,me2w!$F$2:$F$100,0)),"")

in A2

=zpmy_orderadmn!A2

Copy across

perfect , thank you so much

is there a way I can get rid of the dates that come up 00/01/1900 because the first screen is blank , or is it easier just to place a filter in there

thanks

This is the easiest ...

=IF(zpmy_orderadmn!A2="","",zpmy_orderadmn!A2)

sorry , one last thing

i would like to remove the tabs and have them linked to separate files in the same folder

as these are 2 exported files from sap , it will get used by 20 different people it will be easier if they can just dump the files next to the po generator


hope that makes sense

From this

=IF(zpmy_orderadmn!A2="","",zpmy_orderadmn!A2)

to this ... ??

=IF('[zpmy_orderadmn.xlsx]Sheet1'!$A2,"",'[zpmy_orderadmn.xlsx]Sheet1'!$A2)