I have built the example as indicated at http://www.mrexcel.com/tip021.shtml, but am getting #N/A when using the Index-Match function?
It appears the formula is looking is column B for the Match which is OK, I'm just trying to determin why it is not working.
Also, would the tables need to be sorted for this to work?
It appears the formula is looking is column B for the Match which is OK, I'm just trying to determin why it is not working.
Also, would the tables need to be sorted for this to work?