V Lookup with date an min formula

I have a worksheet that has dates in column B and file # in column A. In cell
J12, i have this formula =min(B2:B100), in L12, I have a vlookup to return
the information in column A that matches the date =vlookup(J12,A2:B100,1,0).
I receive a #name error.

Any ideas?

Re: V Lookup with date an min formula

My first idea would be to have you post your question to a group related to
Excel. This is a .net programming newsgroup.

"Scott@CW" wrote in message
news:63E3076C-51E7-4FC4-BF11-487E28336478@microsoft.com...
>I have a worksheet that has dates in column B and file # in column A. In
>cell
> J12, i have this formula =min(B2:B100), in L12, I have a vlookup to return
> the information in column A that matches the date
> =vlookup(J12,A2:B100,1,0).
> I receive a #name error.
>
> Any ideas?

Re: V Lookup with date an min formula

do you have a second idea?

"md" wrote:

> My first idea would be to have you post your question to a group related to
> Excel. This is a .net programming newsgroup.
>
> "Scott@CW" wrote in message
> news:63E3076C-51E7-4FC4-BF11-487E28336478@microsoft.com...
> >I have a worksheet that has dates in column B and file # in column A. In
> >cell
> > J12, i have this formula =min(B2:B100), in L12, I have a vlookup to return
> > the information in column A that matches the date
> > =vlookup(J12,A2:B100,1,0).
> > I receive a #name error.
> >
> > Any ideas?
>
>
>

Re: V Lookup with date an min formula

md's second idea is for me to tell you that my first idea is for you to post
your question in an Excel-related newsgroup instead of a .Net programming
newsgroup.

Robin S.
----------------------------------------
"Scott@CW" wrote in message
news:8ABFB253-37AC-4710-B923-72610038BCCF@microsoft.com...
> do you have a second idea?
>
> "md" wrote:
>
>> My first idea would be to have you post your question to a group related
>> to
>> Excel. This is a .net programming newsgroup.
>>
>> "Scott@CW" wrote in message
>> news:63E3076C-51E7-4FC4-BF11-487E28336478@microsoft.com...
>> >I have a worksheet that has dates in column B and file # in column A. In
>> >cell
>> > J12, i have this formula =min(B2:B100), in L12, I have a vlookup to
>> > return
>> > the information in column A that matches the date
>> > =vlookup(J12,A2:B100,1,0).
>> > I receive a #name error.
>> >
>> > Any ideas?
>>
>>
>>