=VLOOKUP(A2,'Wed by ZIP'!$A$2:$C$416,3,FALSE)
Simple so far. The above is my lookup. How can I make the range more flexible without justing naming a range( I have reasons). I want to put the reference for $c$416 a cell reference on sheet called "Wed by ZIP" and a reference will be in cell G2. Thanks.