So I have been looking and have failed. I am trying to divise a function that will find the smallest values in a range (distantce in miles) for a given employee and output the store number (column header) which is closest to that employee and inversely the employee that has the smallest distance to a given store. I need to do this for the 3 smallest values. I have attached a sample of the sheet in which i am working with. Thanks for looking