look in vba help for using functions in macros. An easy way to do this is
from the vbe just type in vlookup and touch the f1 key.

--
Don Guillett
SalesAid Software

"James Cornthwaite" wrote in message
...
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