<div>
what do you mean by:<br />
How can I make the range more flexible<br />
<br />
???<br />
not clear<br />
gowflow
</div>


what do you mean by:
How can I make the range more flexible

???
not clear
gowflow

<div>
I want the &quot;416&quot; to be a reference in a cell so I can easily change it to any figure based on new length of rows on the sheet. A simple reference to a cell didn't work in the formula.
</div>


I want the "416" to be a reference in a cell so I can easily change it to any figure based on new length of rows on the sheet. A simple reference to a cell didn't work in the formula.

<div>
<div class="content wysiwyg-content">
=VLOOKUP(A2,'Wed by ZIP'!$A$2:$C$416,3,FALSE)<br />
<br />
Simple so far. &nbsp;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 &nbsp;a cell reference on sheet called &quot;Wed by ZIP&quot; and a reference will be in cell G2. Thanks.
</div>
</div>


=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.

tweeking a vlookup

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.