0

I am trying to fetch a few attributes from my database based on the three criteria shown in the image. How do you pull them based on the three criteria: ID, Process & Category.

enter image description here

I know how to use INDEX formula with MATCH formula. How do you use INDEX formula with multiple criteria?

KPrince36
  • 2,886
  • 2
  • 21
  • 29
Linga
  • 945
  • 1
  • 14
  • 31
  • 1
    Have you considered Advanced Filtering? What you have set up is very similar. http://stackoverflow.com/a/32869935/5045578 – Michal Schmitt Oct 26 '15 at 17:20

2 Answers2

1

Assuming sample data and extraction table are located at B1:G28 and I1:N3 (adjust ranges in formulas as required)

Enter this FormulaArray in L2 and copy till last record then to columns M and N

(Enter the FormulaArray pressing [Ctrl] + [Shift] + [Enter] simultaneously, you shall see { } around the formula if entered correctly)

=INDEX( E$1:E$28, MATCH( $I2 & $J2 & $K2, $B$1:$B$28 & $C$1:$C$28 & $D$1:$D$28, 0 ) )

enter image description here

EEM
  • 6,601
  • 2
  • 18
  • 33
0

You can create a stored procedure for the source of your data table that takes your three parameters and filters the data set coming out of the database.

Wyatt Shipman
  • 1,669
  • 1
  • 10
  • 22