Posted to microsoft.public.excel.worksheet.functions

Patti

external usenet poster

Posts: 45

Vlookup with 9E+307

Having an issue with a formula...

VLOOKUP(LOOKUP(9E+307,B:B),B:D,3,FALSE)

I want to find the last date in column B and then pull the date from column
D in the same row.

This works fine as long as there's no data in column C, but if there is, the
formula shows 0 instead of the data in column D.

Any idea why this is happening and how to fix it?

Thanks!

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 isn't working correctly?	Dave F	Excel Discussion (Misc queries)	2	October 14th 06 04:27 AM
VLookup a Vlookup	adamb2000	Excel Worksheet Functions	4	June 28th 06 10:54 PM
VLOOKUP Problem	Ian	Excel Discussion (Misc queries)	3	April 6th 06 06:47 PM
VLOOKUP Limitations	chris_manning	Excel Worksheet Functions	2	August 9th 05 06:23 PM
vlookup data hidden within worksheet		Excel Worksheet Functions	0	January 26th 05 12:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us