Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	0	October 4th 06 06:21 PM
vlookup error	Jim	Excel Worksheet Functions	1	January 25th 06 08:49 PM
VLookup N/A Error	WandaSG	Excel Discussion (Misc queries)	5	December 12th 05 07:48 PM
vlookup error!!	Samantha	Excel Worksheet Functions	1	April 11th 05 11:02 AM
#N/A error with VLOOKUP	Michelle Tucker	Excel Discussion (Misc queries)	4	December 14th 04 01:23 PM

All times are GMT +1. The time now is 09:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us