index match duplicates

[jgedwardsv]

Hi all,

I have a table that calculates various areas between two arrays and shows the smallest areas. I'm using named ranges in a table which I believe is causing some of my issues (lack of understanding).

https://www.dropbox.com/s/ddptn98no1b1kgs/TDFWorksheetTemplate.xlsx?dl=0

This is the spreadsheet I am working on - the issue I am having is on the sheet named "TDFOutput" and the data is being pulled from another table. Right now, when I find the smallest for 2 and 3, it returns the 2nd smallest both times. I'm not sure how to make this go to the next item in the list as the smallest item I am pulling from can contain duplicates.

Any help is greatly appreciated.

Thanks!

 

[jgedwardsv]

Bump for help - still stuck and any assistance is greatly appreciated!

Thanks!