A better formula variable
I have this formula that I would like to use a cell variable rather than the hard coded CHOOSE function. When I put the CHOOSE function into a cell I get the error "The range 2022 Tax Schedule::A:H can't use as a single value". Is there a way to do this?
Thanks for your assistance.
VLOOKUP("Interest Income",CHOOSE(1,2022 Tax Schedule::A:H,2023 Tax Schedule::A:H),8,FALSE)
iMac 21.5″, macOS 12.7