May 24 2019 02:16 AM
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,
Ilker
May 24 2019 02:33 AM
Hi,
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)
Regards
Bernd
May 24 2019 06:26 AM
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?
May 24 2019 06:59 AM
May 24 2019 07:03 AM
Hi Twifoo,
I have filled in the data. So If you change Cell B1 (for example 0155) all data should change with it.
May 24 2019 09:09 AM - edited May 24 2019 11:39 AM