Microsoft Excel
Search from multiple condition IFERROR(INDEX(ArrayResult,MATCH(1,(ArrayCondition1=ValueCondition1)*(ArrayCondition2=ValueCondition2)*(ArrayCondition3=ValueCondition3),0)),"No Match") IFERROR(INDEX(D3:D10,MATCH(1,(B3:B10=D12)*(C3:C10=D13),0)),"No Match") =IFERROR(INDEX(Data!D:D,MATCH(1,(Data!B1:B1000=GH10)*(Data!E1:E1000=GH28)*(Data!F1:F1000=GH19),0)),"") Error using this formula 1. excel ran out of resources while attempting to calculate one or more formula Solution : Make array limitation. Example: array D:D change to D1:D1000 Macros Print Activesheet Macros Print Activesheet Private Sub ButtonPrintEpson_Click() Application.ScreenUpdating = False ActiveSheet.PrintOut Application.ScreenUpdating = True End Sub Macros Print To PDF VBA Macros Print To PDF Private Sub ButtonPrint_Click() Application.ScreenUpdating = False ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:="C:\Users\~User~\Documen