Hi guys,
as I'm trying to create a custom vlookup function for our office, I am wondering if there is a way to help users with description of arguments, like there are in dialog box for other functions? The first argument would be lookup value and the other argument column index number.
I would also like to create a drop down menu for the later one, that would help the user to select correct number, if user chose to write the function manually; something like the "return_type" argument like the weekday function has.
Is any of that possible? Description of arguments and drop down menu?
as I'm trying to create a custom vlookup function for our office, I am wondering if there is a way to help users with description of arguments, like there are in dialog box for other functions? The first argument would be lookup value and the other argument column index number.
I would also like to create a drop down menu for the later one, that would help the user to select correct number, if user chose to write the function manually; something like the "return_type" argument like the weekday function has.
Is any of that possible? Description of arguments and drop down menu?