Posted to microsoft.public.excel.misc

Scott@CW

external usenet poster

Posts: 62

vlookup error

I am getting the folllowing error (#N/A) with the below formula

=VLOOKUP(F1,A20:D680,4,FALSE)

In cell F1 is this formula
='180 Report'!D6

Please help. I am trying to get the column information in column D according
to the value from F1.

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	[email protected]	Excel Worksheet Functions	5	May 31st 07 02:52 PM
Vlookup value not available error	[email protected]	Excel Discussion (Misc queries)	1	December 30th 06 09:44 PM
VLOOKUP error in VBA	[email protected]	Excel Discussion (Misc queries)	1	September 20th 06 03:57 PM
VLookup N/A Error	WandaSG	Excel Discussion (Misc queries)	5	December 12th 05 07:48 PM
vlookup error	Josh O.	Excel Worksheet Functions	6	December 30th 04 05:16 PM

All times are GMT +1. The time now is 05:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us