Vlookup returning No data.

[Alex H]

Hi. In Access I have a query which groups and counts a Medium Date field as
follows:
Marked: Format([Date Started],"mmm-yy")
StartCount: Count(Format([Date Started],"mmm-yy"))

In Excel I bring the data into a worksheet, 'Data from Mis' and have set the
field properties to Custom Date MMM-YY

On a second sheet, I am trying to set A59 (formatted Custom: mmm-yy) Vloopup
as follows:
=VLOOKUP(A59,'Data from MIS'!D440,'Data from MIS'!E4:E40,FALSE)

I am returning an N/A -

Can someopne tell me why this is not working - is it a format type problem?

Thanks

Alex

 

[Anne Troy]

Alex, click on each cell---the one you're looking up and the one that should
be found---and see exactly what the values are in the formula bar. Then work
with the values and not the formats.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Tom Ogilvy]

When the help say the third argument specifies the column from which to
return a value, it means the count relative to the second argument. So you
would have
=VLOOKUP(A59,'Data from MIS'!D4:E40,2,FALSE)
I would think

 

[Alex H]

Hi Anne

Well in that case it should work shouldn't it? The data is below.
Shouldn't the cell I'm working with show 72?

'Data from MIS'!D15, shows Aug-04; 'Data from MIS'!E15 shows 72
A59 shows Aug-04 in cell, and 01/08/04 in Formula Bar.


Than ks

Alex

Alex, click on each cell---the one you're looking up and the one that
should
be found---and see exactly what the values are in the formula bar. Then
work
with the values and not the formats.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

Hi. In Access I have a query which groups and counts a Medium Date field as
follows:
Marked: Format([Date Started],"mmm-yy")
StartCount: Count(Format([Date Started],"mmm-yy"))

In Excel I bring the data into a worksheet, 'Data from Mis' and have set the
field properties to Custom Date MMM-YY

On a second sheet, I am trying to set A59 (formatted Custom: mmm-yy) Vloopup
as follows:
=VLOOKUP(A59,'Data from MIS'!D440,'Data from MIS'!E4:E40,FALSE)

I am returning an N/A -

Can someopne tell me why this is not working - is it a format type problem?

Thanks

Alex

 

[Alex H]

Thanks Tom - that got it - spot on

Many thanks both for your help!

Alex

When the help say the third argument specifies the column from which to
return a value, it means the count relative to the second argument. So
you
would have
=VLOOKUP(A59,'Data from MIS'!D4:E40,2,FALSE)
I would think

--
Regards,
Tom Ogilvy

Hi. In Access I have a query which groups and counts a Medium Date field as
follows:
Marked: Format([Date Started],"mmm-yy")
StartCount: Count(Format([Date Started],"mmm-yy"))

In Excel I bring the data into a worksheet, 'Data from Mis' and have set the
field properties to Custom Date MMM-YY

On a second sheet, I am trying to set A59 (formatted Custom: mmm-yy) Vloopup
as follows:
=VLOOKUP(A59,'Data from MIS'!D440,'Data from MIS'!E4:E40,FALSE)

I am returning an N/A -

Can someopne tell me why this is not working - is it a format type problem?

Thanks

Alex