I'm trying to find a formula that kind search in multiple criteria. (see attachment for the Excel sheet)
It needs to search in the Groups in Sheet ''1'', From there it needs to search on row 2, and from there it needs to matching criteria on the first sheet B1. So when I change the Value in B1 all data should change. Could someone please help me with this?
i create a userdefinded function. Certainly there is also a formula for this, but i like VBA
Function GetData(strGroup As String, strNr As String) As Double Dim rngFindColumn As Range Dim rngFindRow As Range
Set rngFindColumn = Tabelle2.Rows(2).Find(what:=strGroup, lookat:=xlWhole) If Not rngFindColumn Is Nothing Then Set rngFindRow = Tabelle2.Range("A:A").Find(what:=strNr, lookat:=xlWhole) If Not rngFindRow Is Nothing Then GetData = Tabelle2.Cells(rngFindRow.Row, rngFindColumn.Column).Value End If End If