Thread: VLOOKUP error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Solitary Solitary is offline
external usenet poster
 
Posts: 1
Default VLOOKUP error

=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.