"Myrna Larson" wrote...
Or INDEX(VF1:VF29,MATCH(E7,ProductType,0))
....

Indeed!

When did Microsoft expand Excel to 578 or more columns? My version only
extends to column IV.

Maybe the OP was goofing with range references in 'col VF', but I took him
at his word that these were named ranges.