Data inconsistency is the usual culprit. Probably the values within the
lookup col C in "Budget" are text numbers, while the lookup values in A2 down
are real numbers
Try:
=VLOOKUP(A2&"",Budget!$C$2:$Z$10000,6,FALSE)
which will convert the real numbers in A2 down to text numbers
If you need to add leading zeros in converting it to text numbers,
try instead something like:
=VLOOKUP(TEXT(A2,"0000"),Budget!$C$2:$Z$10000,6,FA LSE)
Adjust the "0000" part to suit
I disregarded your comment below, which was confusing to me:
If I enter the formula in the next cell, Excel will reflect the correct value.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Solitary" wrote:
=VLOOKUP(A2,Budget!$C$2:$Z$10000,6,FALSE)
This is the formula that I am entering into my spreadsheet. However, when I
copy it downwards, I get a #N/A, even though there is a match for the lookup
value in the table. If I enter the formula in the next cell, Excel will
reflect the correct value. Just cannot seem to get it to work when I use the
Autofill to copy the formula downwards.