Forum Discussion
formula error Index and Match function
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...
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?
- Thank you very much Riny_van_Eekelen for taking time out to answer my query. I can do this now! The cell reference was getting changed for the following rows resulting in me being able to extract only the first row. I put a dollar sign to fix the row and it got cured of its error. Thanks again!!
