Help with Index Custom Function

[david000]

[vba]
Function xIndex2(arr1, arr2, arr3, arr4)

With Application.WorksheetFunction

xIndex2 = .Index(arr1, .Match(arr2, .Index(arr3, , arr4)), 0) 'arr4 selects the column.
End With

'I'm trying to do this formula below. I get an "Arugument Not Optional Error" -
'When I Skip the ROW Arrgument in place of the Column one.
'=INDEX(D23,MATCH(I2,INDEX(E2:F3,,1),0))< Empty Row Argument Causing ERROR. In the VB Only...Not the Worksheet

'I need an additional INDEX but with a missing ROW argument!
'works on the sheet not in the code???
End Function


[/vba]

This link Example3 is what I'm mainly trying to do.

Link >>> contextures.com/xlFunctions03.html#IndexMatch2


I'm really not a huge fan of SUMPRODUCT, because, I can never remember when to use that "--" operator!!! At least with, "Index - text" , "Match- number", you know what to expect.

Exept in this case of course!

I've been over thinking this dumb issue too long.


I'm posting a new sample it's as complete as I can make it...

I'm really sorry about any confusion I may have casued - I'm dumb


Attachment 6156< New Example!!!!