MATCH formula with external lookup_array data
Solved/Closed
Albert17
-
Mar 2, 2010 at 07:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 2, 2010 at 08:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 2, 2010 at 08:22 AM
Related:
- MATCH formula with external lookup_array data
- Music match jukebox - Download - Audio playback
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Tmobile data check - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 2, 2010 at 08:22 AM
Mar 2, 2010 at 08:22 AM
Why not go for UDF
Some thing like
Function myMatch(searchString As String, rangeString As String) as variant
Set myRange = Range(rangeString )
myMatch = Application.WorksheetFunction.Match(searchString , myRange, 0)
End Function
Some thing like
Function myMatch(searchString As String, rangeString As String) as variant
Set myRange = Range(rangeString )
myMatch = Application.WorksheetFunction.Match(searchString , myRange, 0)
End Function