software

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 Functionbut 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

Please decide where you want to post

--
Don Guillett
SalesAid Software

quot;James Cornthwaitequot; gt; wrote in message
...
gt;I have written my own function FindNominal (as below) in a macro in excel.
gt;I
gt; want to use this function repeatedly in my excel spreadsheet.
gt;
gt;
gt; Function FindNominal(NomCode)
gt;
gt; FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)
gt; End Function
gt;
gt;
gt; but it does NOT work.
gt;
gt;
gt; It reports
gt; Vlookup is not recognised.
gt; Do i need to write an import statement?
gt;
gt; IMPORTDOC is defined as a range of cells in excel by the name, define
gt; command.
gt; I take it this is acceptable?
gt;
gt; Thanks
gt;
gt;
gt;
Function FindNominal(NomCode)

FindNominal = WorksheetFunction.VLookup(NomCode, Range(quot;IMPORTDOCquot;), 5,
False)
End Functionquot;James Cornthwaitequot; gt; wrote in message
...
gt;I have written my own function FindNominal (as below) in a macro in excel.
gt;I
gt; want to use this function repeatedly in my excel spreadsheet.
gt;
gt;
gt; Function FindNominal(NomCode)
gt;
gt; FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)
gt; End Function
gt;
gt;
gt; but it does NOT work.
gt;
gt;
gt; It reports
gt; Vlookup is not recognised.
gt; Do i need to write an import statement?
gt;
gt; IMPORTDOC is defined as a range of cells in excel by the name, define
gt; command.
gt; I take it this is acceptable?
gt;
gt; Thanks
gt;
gt;
gt;