Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
63
Views
Topic starter
In the attached file I looked for a certain figure
And I did not get a normal result
If I can fix the formula,
I'd love to understand why it did not work - so what should I choose Array?
And I did not get a normal result
If I can fix the formula,
I'd love to understand why it did not work - so what should I choose Array?
Note that I need the column of dates to be in the middle of the table.
thank you!!
Posted : 28/05/2019 10:17 am
Hello,
The INDEX function has following syntax: INDEX(array, row_num, [column_num])
Your formula is wrong as you are trying to find the column_num in the row_num area and vice versa. The formula should be =INDEX(A2:G21,MATCH(J6,D2:D21,0);MATCH(K6,A1:G1,0))
Posted : 28/05/2019 5:19 pm
