Xlookup

[Josh_Waldner]

Good Afternoon

i am wondering if a way exists for the return array to automatically adjust its size to a specified value according to a different cell. i am thinking of a settings page with A1 would contain "20" where the return array would be Sheet2 A1:A20

[#2 · Accepted solution]

@Josh_Waldner Use this as the return array:

INDIRECT("Sheet2!A1:A"&A1)