Cross sheet reference - I would like info in column b on sheet A to appear in column Y on sheet Z

Dan Kirk

Column Y on sheet Z has no data in it. Many of the cells in column b on sheet A are blank.

I've tried

=IF(NOT(ISBLANK({column b on sheet A}), 1, 0))

=({column b on sheet A})

=INDEX({column b on sheet A}, MATCH([column Y]@row, 0))

=INDEX({column b on sheet A})

I would also like it to update when changes are made.

I feel like I'm missing something obvious.

Thanks for any help,

Dan

Sarah Keortge

INDEX/MATCH is definitely the way to go and you just need to adjust the MATCH formula. You'll need to define both the column in sheet Z and in sheet A that match between the two sheets - that's what will be used to look up the correct data in sheet A.

=INDEX({column b on sheet A},MATCH([matching column in sheet Z]@row,{matching column in sheet A},0)

Dan Kirk

Thank you, that worked. I misunderstood the function of MATCH.