Hi,
I currently have a formula using INDIRECT but was hoping to use Choose and Match in place to keep spreadsheet fast. This is my current formula below, where H2 is the current name of the worksheet I want to reference. I want to variably change the worksheet reference based on H2. Thanks for the help!
=VLOOKUP(B3,INDIRECT("'"&H2&"'!"&"A:S"),19,0)
I currently have a formula using INDIRECT but was hoping to use Choose and Match in place to keep spreadsheet fast. This is my current formula below, where H2 is the current name of the worksheet I want to reference. I want to variably change the worksheet reference based on H2. Thanks for the help!
=VLOOKUP(B3,INDIRECT("'"&H2&"'!"&"A:S"),19,0)