Please post your initial formula and the first one giving #NA.
I guess that the reference to the table is relative instead of absolute,
something like A1:A100 instead of $A$1:$A$100.

--
Kind regards,

Niek Otten

"Rochelle" wrote in message
...
I have a vlookup retrieving info from another page in the same workbook. To
make things easy I copy the first row of formulas to the rows below and it
works up to a ceratin row, and the I get #N/A. The error description is
"Inconsistent formula" and the trace has a line from the lookup value to
the
cell next to it and then a dotted line to another cell two rows up.
I have no clue why there is this difference - I have changed cell formats
both on the source page and in my report page; the formula is the same as
the
rows above (they work, btw) so what is the problem with the rest of the
rows?
Any comments or suggestions?