Posted to microsoft.public.excel.misc

external usenet poster

Posts: 11

vlookup returning #value!

I have dates in on table and prices in another
using the formula
VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2,FALSE)

table names are "low" "mid" and "high"

VLOOKUP(F11,Dates,2,FALSE) returns "low"
but when nested within the vlookup I get #value!

please help

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 always returning the same value!	Jennifer Cali	Excel Discussion (Misc queries)	10	April 23rd 23 09:08 AM
Vlookup returning a YES or NO	Rob	Excel Worksheet Functions	6	September 18th 08 02:30 AM
Vlookup returning #n/a	TRYIN	Excel Worksheet Functions	2	February 8th 08 07:56 PM
vlookup returning a #N/A value	Ian	Excel Worksheet Functions	5	May 17th 06 02:58 PM
vlookup returning sum	Rose	Excel Worksheet Functions	1	July 14th 05 10:47 PM

All times are GMT +1. The time now is 08:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us