I've attached a file where I am attempting to use a cross reference in order to find specific data points based on two variables. I am able to get the right result for the first cell, but after that all it comes up with is #N/A errors. I've tried change the order of the referencing values, but it doesn't seem to help. Any help is greatly appreciated, I assume I'm missing something pretty obvious.
Nathan
Bookmarks