Value Search On 3 Criteria

Occasional Contributor

Good morning buddies,


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?


Thanks in advance


Best regards,



5 Replies



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

End Function


call from cell B3: =GetData($B$1;$A3)






Thank you for your reply but I don't know what a VBA means.

Isn't there just a formula that I can add into cell B3?

Perhaps you need to manually enter your desired results, then attach your file again so I can understand the logic of the formula you need. Formula, not VBA, should be the default solution.



Hi Twifoo,


I have filled in the data. So If you change Cell B1 (for example 0155) all data should change with it. 

You can try this formula in B3, copied down rows: