M
MSCom
Neuer Benutzer
Threadstarter
- Dabei seit
- 20.09.2016
- Beiträge
- 1
Hi,
First post, so apologies if this is very or too basic.
I'm trying to create a reporting dashboard, a small sample of which is below.
I want to be able to change the fields in B2 to E2 in order to get the results in B5 to E6. I'm trying to use INDEX with MATCH (which might not be the best way I guess) but I get a #REF! error. This happens when I add a second MATCH criteria.
You may have noticed I am using a German keypad by the ";" instead of a comma but my formulas are set to English. Problem perhaps?
The example formula in C5 is =INDEX(F11:F22;MATCH(B2;B11:B22;0);MATCH(C2;C11:C22;0))
I've also tried, from searching on Google, to do simpler formulas with INDEX & MATCH but even when I follow the formula exactly, it doesn't work.
Can anyone help?
Mike
First post, so apologies if this is very or too basic.
I'm trying to create a reporting dashboard, a small sample of which is below.
I want to be able to change the fields in B2 to E2 in order to get the results in B5 to E6. I'm trying to use INDEX with MATCH (which might not be the best way I guess) but I get a #REF! error. This happens when I add a second MATCH criteria.
You may have noticed I am using a German keypad by the ";" instead of a comma but my formulas are set to English. Problem perhaps?
The example formula in C5 is =INDEX(F11:F22;MATCH(B2;B11:B22;0);MATCH(C2;C11:C22;0))
I've also tried, from searching on Google, to do simpler formulas with INDEX & MATCH but even when I follow the formula exactly, it doesn't work.
Can anyone help?
Mike
