I'm collating cells from different sheets using
=VLOOKUP(Sheet1!A1:A10, Sheet1!A1:A10, 1, FALSE)
The issue is that some cells have characters that have more than 256 characters. I need to import the whole column of cells together to account for the addition of future rows.
Are there any workarounds to get the data to display?