Cannot get formula to copy - getting #N/A -2010

Hi,

I have searched and searched and cannot resolve this though it's probably simple. I'm trying to copy the formula from 3 cells or even 1 at a time and I keep getting #N/A. I have tried:

1. Dragging the (+) from the last cell to the bottom row.
2. Copy and Pasting Special - Values and Number formatting (as it says on my instructions)
3. Copying and Paste Special - Copy forumlas
4. Tried KuTools - they recommended search and replace
5. Tried various other suggestions of the web and in help.

The reference exists (site list).

=VLOOKUP(D36800, sitelist!$A$2:$B$637, 2, FALSE) - Column 1 (Value = 1)
=VLOOKUP(D36800, sitelist!$A$2:$D$642, 3, FALSE) - Column 2 (Value = CLASSIC)
=VLOOKUP(D36800, sitelist!$A$2:$D$642, 4, FALSE) - Colmun 3 (Value - Finance Related Services)

1 CLASSIC Finance Related Services

The formula works for previous months but will not work for this one and I just can't figure out why. Please help.

Sambo,

Thanks so much for your reply. I am trying to rename sensitive data and still keep the formulas in tact. So far, no luck. Will keep trying.

I figured it out. The column it was searching on had leading spaces so therefore, the data could not be found. Thanks anyway Sambo kid!