Posted to microsoft.public.excel.misc

external usenet poster

Posts: 28

vlookup using dates

User trying to find the value on a certain date can enter that date (a1).
vlookup will search column A for the requested date and then return the
associated value that is in column b.... Column A10:a100 = dates. Column
B10:b100= values... =vlookup(a1,a10:b100,2) returns #N/A

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 and dates!	KneeDown2Up	Excel Worksheet Functions	6	April 2nd 07 08:44 AM
lookup/vlookup for dates, please help!	soozanne	Excel Worksheet Functions	1	February 23rd 06 04:00 PM
dates and vlookup	grapes	Excel Worksheet Functions	1	February 2nd 06 09:19 PM
VLOOKUP calendar dates	Stanley	Excel Discussion (Misc queries)	5	January 19th 06 05:00 PM
VLookUp with Dates	o1darcie1o	Excel Worksheet Functions	4	September 2nd 05 01:18 PM

All times are GMT +1. The time now is 07:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us