Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to create a user defined function to simplify an INDEX-MATCH lookup
Public Function XLOOKUP(Range, Column, Row XLOOKUP = Index(Range, Match(Row, Offset(Range, 0, 0, 0, 1), 0), Match(Column, Offset(Range, 0, 0, 1, 0), 0) End Functio However, when I use the function I get an error Compile error Sub or Function not define and the first OFFSET function is highlighted Any help would be appreciated Thanks Mark Graesse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
user defined function help | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
USer Defined Function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |