david000
07-05-2007, 05:15 PM
Function xIndex(arr1, arr2, arr3)
With Application.WorksheetFunction
xIndex = .Index(arr1, .Match(arr2, arr3, 0))
End With
'I need an additional INDEX but with a missing ROW argument!
'works on the sheet not in the code???
'=xindex($D$2:$D$3,K2,INDEX(E2:F3,,2))
End Function
I really really want to add an additional Index into this Custom Function, but I can't get around the required ROW argument for index in VB where it's not required in Excel (at least you can skip it!)?!
Or ANYTHING that allows me to choose the column dosen't have to be INDEX.
I'm sure someone has this answer in thier trick bag! So, give it up please!
Thanx!
With Application.WorksheetFunction
xIndex = .Index(arr1, .Match(arr2, arr3, 0))
End With
'I need an additional INDEX but with a missing ROW argument!
'works on the sheet not in the code???
'=xindex($D$2:$D$3,K2,INDEX(E2:F3,,2))
End Function
I really really want to add an additional Index into this Custom Function, but I can't get around the required ROW argument for index in VB where it's not required in Excel (at least you can skip it!)?!
Or ANYTHING that allows me to choose the column dosen't have to be INDEX.
I'm sure someone has this answer in thier trick bag! So, give it up please!
Thanx!