Thanks Tom - that got it - spot on

Many thanks both for your help!

Alex

"Tom Ogilvy" wrote in message
...
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


"Alex H" wrote in message
...
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'!D4:D40,'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