I’m trying to make a simple low cost selection table for airline tickets.  I have multiple named ranges for the lowest prices per airline, so Air1 will have 5 different fare options, Air2 will have 5, etc.  I’ve used conditional formatting to highlight the lowest per airline, now I want to display which airline has the lowest fare of all of them along with the fare. I have a min(all of the values) which displays the lowest fare of all airlines/fare options, but I also want to display the airline for that value.  Using the cell that has the airline name is not easy as it’s different in relation to the minimum fare depending on which one it is.  I thought using the range name would be relatively easy.  Any ideas or alternatives?

​I’m trying to make a simple low cost selection table for airline tickets.  I have multiple named ranges for the lowest prices per airline, so Air1 will have 5 different fare options, Air2 will have 5, etc.  I’ve used conditional formatting to highlight the lowest per airline, now I want to display which airline has the lowest fare of all of them along with the fare. I have a min(all of the values) which displays the lowest fare of all airlines/fare options, but I also want to display the airline for that value.  Using the cell that has the airline name is not easy as it’s different in relation to the minimum fare depending on which one it is.  I thought using the range name would be relatively easy.  Any ideas or alternatives?  Read More

​