Link a column to another sheet?

Kimbh

Hi, If you set up one cell to link to another sheet. Can you make the whole column link to that column, or do I have to use a formula? I ask because I'm struggling with formulas and the xlookup I use in Excel is not uploading correctly due to how the workbook is set up in excel.

Thank you

Kim

Garrett Henke

@Kimbh Would an INDEX/MATCH formula work?

=INDEX({Value to lookup range}, MATCH([Value to match]@row, {Value to match range}, 0))