software

It sounda as though your data is not structured to take full advantage of the
VLOOKUP feature. You do not need to set a RangeName for each value you wish
to lookup. Say you have your Cities in column M, with their respective
values in column N, then try replacing your VLOOKUP formula with this one.....

=IF(E2=0,quot;quot;,VLOOKUP(E2,M:N,2,FALSE))

hth
Vaya con Dios,
Chuck, CABGx3
quot;Equaliserquot; wrote:

gt; This is the formula that I am using which works very well. =IF(E2=0,quot;
gt; quot;,(VLOOKUP(E2,Worcester,2,FALSE))). I have a range named WORCESTER for
gt; looking up the answer that I need.
gt; This is fine if the text in cell E2 DOES =Worcester. BUT, cell E2 will
gt; sometimes =Portsmouth so I just edit my formula, which is not ideal. How can
gt; I extend the formula so that it uses a different lookup range depending on
gt; what is in cell E2?
gt; Does this make sense?
gt;
gt;