Hi Guys - I'm trying to fix someone's mess in the office and got stuck. Now its my mess! What I'm trying to do is lookup values based on ID and DX number. I used a combination of index/match but I'm not getting the desired results.
In the attached sheet on the Analysis tab im trying to fill in the values from column E to column L. The lookup criteria is based on the ID and the DX number. The problem im running into is that the DX number is in multiple columns in the data tab - the DX number is in column M-P on the data tab. I want to return the value is there is a match on the ID # and the DX in any of the those columns. The formula works for the first couple of the rows but in the 3rd row it is not working. There is a match on ID#10000 and DX number 272.4 in the data tab.
Any thoughts?
Bookmarks