Do Vlookups in code
Closed
Corina
-
Jun 9, 2010 at 06:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 10, 2010 at 01:27 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 10, 2010 at 01:27 AM
Related:
- Do Vlookups in code
- Samsung keypad reset code - Guide
- Battery reset code - Guide
- Samsung volume increase code - Guide
- How to get whatsapp verification code online - Guide
- Usa country code for whatsapp - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 06:40 PM
Jun 9, 2010 at 06:40 PM
It is not VLOOKUP that prevents. it is IF statements. You cannot have more than 7 nested ifs. So either break up the the if block to no more than 7 by using more than 1 columns.
Other option would be to use a user defined function
Other option would be to use a user defined function
Hi ,, Thanks but what is the user defined funcition
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 10, 2010 at 01:27 AM
Jun 10, 2010 at 01:27 AM
user defined function is what is says a user defined function. Some functions are inbuilt in excel. and an excel user can create his or her own function too. It is like sub, other than it returns value
Function myFunction(......) as String/variant or ...
ENd Function
Function myFunction(......) as String/variant or ...
ENd Function