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)