I am trying to create a function that will act like LOOKUP but not care if
the data is in ascending order or not. TargetScore is a number like .2309,
Scorelist will also be decimal numbers like .2565, and names are just that
Names. This is what I have so far.
Function GetName(TargetScore As Variant, ScoreList() As Variant, Names() As
Variant) As Variant
On Error Resume Next
Dim i As Integer
For i = 0 To UBound(ScoreList)
If ScoreList(i).Value = TargetScore Then
GetName = Names(i).Value
End If
GetName = TargetScore
Next
Application.Volatile
End Function
I can't get this to work at all. I have tried using paramarray but it is
not able to be used with multiple arrays.
Dave Marden
Bookmarks