If you're retyping the formula, then this isn't the problem.

But if you're copying (or even dragging down the column), then that range on
Sheet5 will change with every row you drag down.

For instance, I get this on the second row after I drag it down:

=VLOOKUP($AK8,Sheet5!D4:CE35,80,FALSE)

Notice that the range on Sheet5 now points at D4:C35. If the matching data was
above that range, you'll get #n/a's.

I'd use:

=VLOOKUP($AK7,Sheet5!$D$3:$CE$34,80,FALSE)

so that those references on sheet5 don't change when I copy the formula.





Danopnu wrote:

I have a working LOOKUP function in a spreadsheet referencing another page,
but when I copy it, or even retype it in the other rows, it returns the #N/A
error. The only difference that I can see is that for some of the other rows,
there are 0 amounts- could that be messing it up? This is what the working
one is:
=VLOOKUP($AK7,Sheet5!D3:CE34,80,FALSE), and this the non working in the
next row:
=VLOOKUP($AK8,Sheet5!D3:CE34,80,FALSE)

--

Dave Peterson