Lookup in VBA

[Bill Martin]

I was about to embark on moving some VLOOKUP type code into a VBA module
using the "WorksheetFunction" approach. First however, I thought I'd check
whether there was an easier, more direct approach.

Following my nose, I find the VBA development help system provides a list of
available native VBA functions which include LOOKUP so I don't have to mess
with the "worksheetfunction" approach. Wonderful.

I follow the VBA help system for syntax and plug it into a VBA module. VBA
provides a compile error though "Sub or Function not defined".

What's going on? The VBA help system helpfully describes the function but
the compiler does not recognize it. Do I need to link to something? I've
never stumbled across such a thing in VBA before.

Thanks.

Bill

 

[Bill Martin]

Now I understand. I misread the Help system. Moving right along...

Bill