Quote:
Originally Posted by Gumby
Given =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), I think you have the lookup_value and table_array flipped.
It should be =VLOOKUP(C1, A:B,2,"false").
The way you have it, you won't find the two bolded dates (from column A) in column C.
|
Quote:
Originally Posted by Dasani
Hmm, so basically column A to have the same dates as column D? I don't really know anything about excel, but it sounds like the general idea. 
Something like this perhaps?
http://www.mediafire.com/?vkcth92dhxtc8ot |
DING DING DING
I figured it out!!!! Thanks Gumby for the formula, exactly what I needed. (Also to produce Dasani's results)
And thanks to all of you who helped.
