How can I specify all columns of a table in the HLOOKUP function?
I'm running Numbers on an iMac. I specify the range for the HLOOKUP as Table 1::$C$2:AL$32. Is there a way to specify all columns of a table instead so that I can copy the formula and use it in another sheet where the number of columns might be different?
iMac 21.5″, macOS 12.7