Hi taketwo,

you currently have the range name "options" defined as Summary!E3:E5. If you change the definition for "Options" to be Database!$B$2:$D$2, you won't have to worry about maintaining two lists, because then VLOOKUP uses the MATCH to find the column for the lookup in the Database table directly.