vlookup array dependant on selection from data val list.

[markswjh]

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?

 

[Dave Patton]

N.B. My post shows n/a; I do not have your data.
Edit the range as necessary. A2 on my example is a number; revise the formula if it is Text.

T202010a.xlsm
	A	B
1
2	2018	#N/A
3b

Cell Formulas
Range	Formula
B2	B2	=CHOOSE(MATCH(A2,{2018,2019,2020},0),VLOOKUP(B8,'Updated COV Boundaries'!$C$4:$D$54,2,0),VLOOKUP(B8,'Updated COV Boundaries'!$E$4:$F$54,2,0),VLOOKUP(B8,'Updated COV Boundaries'!$G$4:$H$54,2,FALSE))

 

[markswjh]

Thanks Dave! That is perfect! Sorry I would have added spreadsheet but it is full of sensitive data!

Thanks
Will

 

[Dave Patton]

Thanks for the feedback.