Jan 28 2022 07:57 AM - edited Jan 28 2022 08:13 AM
I have created a dropdown of names and wanted to see the quality scores of each one in four different quality categories. So, each time I change the name using the dropdown I should be able to fetch the corresponding 4 rows.
=INDEX($A$2:$F$17,MATCH($I4,$B$2:$B$17,0),MATCH(H$4,$A$2:$F$2,0))
However, I am being able to get only the first category, and the rest of them are #N/A errors. For all the names I am only being able to fetch the value of only one category from the mother table. Since morning tried several times to no avail.
Please help me!
Jan 28 2022 08:25 AM
@kivaavik Not sure what you are trying to achieve but I find it a bit odd that the "match ranges" are part of the array you index. Normally you would refer to row and column headers. Perhaps move column B to column A and then change the indexed range to $B$3:$F$17. But perhaps I'm all wrong. can you upload a screenshot of the relevant part of the file?
Jan 28 2022 12:07 PM
Jan 30 2022 08:32 PM
Jan 30 2022 08:36 PM
Jan 30 2022 08:37 PM
@Sergei Baklan Thanks.