I have a list of data and i'm trying to extract info from the list using an index/match formula. This is working but only until I change one of the drop downs from the 1st option to the next and then the answer for the formula is coming back #REF . I think somehow I need to incorporate the other options I have in my drop down lists so when these options are selected then the formula will bring back the appropriate data. Any ideas?
thank you!
thank you!
