Using Named range in a Vlookup

I have a good understanding on how to use Vlookup except that when doing a fill down, it increments the lookup range.

I looked at defining the range I would use in the formula

=IF(B7<>"",VLOOKUP(B7,Sheet2!A5:D24,C2,FALSE),"") to

=IF(B7<>"",VLOOKUP(B7,MyList,C2,FALSE),"")

C2 is reference to 2, 3 or 4 which reads four columns based on whats in B7 and returns either column 2,3,4 pricing variables.

I defined the mylist as suggested in the function bar area but methinks that there is a trick in the syntax and as usual MS Help is as clear as mud. I tried single and double quotes an parenthesis, even the formula assist yields no clues.

The idea of the named range is so that I do not have to go through a manual edit of the range of cells after the fill down.

Any help will be appreciated for this dumb old man