using excel functions in a macro - my first macro! ?

I have written my own function FindNominal (as below) in a macro in excel. I
want to use this function repeatedly in my excel spreadsheet.


Function FindNominal(NomCode)

FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)
End Function


but it does NOT work.


It reports
Vlookup is not recognised.
Do i need to write an import statement?

IMPORTDOC is defined as a range of cells in excel by the name, define
command.
I take it this is acceptable?

Thanks

pls post in ONE group only

--
Don Guillett
SalesAid Software
[email protected]
"James Cornthwaite" <[email protected]> wrote in message
news:[email protected]...
>I have written my own function FindNominal (as below) in a macro in excel.
>I
> want to use this function repeatedly in my excel spreadsheet.
>
>
> Function FindNominal(NomCode)
>
> FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)
> End Function
>
>
> but it does NOT work.
>
>
> It reports
> Vlookup is not recognised.
> Do i need to write an import statement?
>
> IMPORTDOC is defined as a range of cells in excel by the name, define
> command.
> I take it this is acceptable?
>
> Thanks
>
>
>
>