V Lookup with date an min formula

[=?Utf-8?B?U2NvdHRAQ1c=?=]

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?

[md]

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" <Sc*****@discussions.microsoft.comwrote in message
news:63**********************************@microsof t.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?

[=?Utf-8?B?U2NvdHRAQ1c=?=]

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" <Sc*****@discussions.microsoft.comwrote in message
news:63**********************************@microsof t.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?

[RobinS]

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" <Sc*****@discussions.microsoft.comwrote in message
news:8A**********************************@microsof t.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" <Sc*****@discussions.microsoft.comwrote in message
news:63**********************************@microso ft.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?