Hi,
For some reason, my index match formula isn't working. I want to automatically populate two other boxes based on a value entered in another box that is selected from a drop down list. I am using an index match for each box separately, but it returns with #N/A.
=INDEX(array of desired value,MATCH(value from drop down list,array of value from drop down list,0),0)
I can only think of two reasons for this; that the drop down list is complicating the formula, or that because the value from the drop down list corresponds to the same number across lines, it may confuse the formula. For instance, if the value selected from the list is "A", it will correspond to "B" in many different entries.
Does anyone have any ideas on how to fix this?
For some reason, my index match formula isn't working. I want to automatically populate two other boxes based on a value entered in another box that is selected from a drop down list. I am using an index match for each box separately, but it returns with #N/A.
=INDEX(array of desired value,MATCH(value from drop down list,array of value from drop down list,0),0)
I can only think of two reasons for this; that the drop down list is complicating the formula, or that because the value from the drop down list corresponds to the same number across lines, it may confuse the formula. For instance, if the value selected from the list is "A", it will correspond to "B" in many different entries.
Does anyone have any ideas on how to fix this?
