Hello all
I'm trying to create a Vlookup formula which changes the data array dependant on the the value of a data validation list choice.
like the following
if "2018" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$C$4:$D$54,2,FALSE)
if "2019" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$E$4:$F$54,2,FALSE)
if "2020" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$G$4:$H$54,2,FALSE)
Etc.
Does this make sense? Is it possible?
I'm trying to create a Vlookup formula which changes the data array dependant on the the value of a data validation list choice.
like the following
if "2018" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$C$4:$D$54,2,FALSE)
if "2019" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$E$4:$F$54,2,FALSE)
if "2020" is selected it would be =VLOOKUP(B8,'Updated COV Boundaries'!$G$4:$H$54,2,FALSE)
Etc.
Does this make sense? Is it possible?