have your tried making the rows in your lookup source absolute?

IE, instead of:
=VLOOKUP(A6,$E6:$F10,2)

try:
=VLOOKUP(A6,$E$6:$F$10,2)

Good Luck.

"chili" wrote:


Hi All,

I have been struggling with this problem for several days as I need to
run it to add in for street codes and I learnt vlookup from other
examples given around.

I used vlookup on 1st cell A2. It works Ok. After that, I used the same
formula, copy & paste to the rest of the cells. It comes out N/A error.
Traced through, and turned out the formula ( lookup highlighted blue,
table array is green) the highlight green area which table array
supposed to be in has run/gone down to another cell ( from E1 to E2).

In all, how do I successfully duplicate & apply vlookup to other cells
too? or can I "fixed" the highlighted table array not to run? I have
tried =VLOOKUP(A6,$E6:$F10,2) putting $ sign on it, but it is still not
correct.


Thank you very much for replying,




--
chili