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,"",VLOOKUP(E2,M:N,2,FALSE))

hth
Vaya con Dios,
Chuck, CABGx3



"Equaliser" wrote:

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