返回单元格范围内的MIN值，然后从行中查找字 [英] Return MIN value in a range of cells, then lookup word from row

问题描述

这个问题听起来很复杂-但我想不出更好的方法来解释它.

The question sounds convoluted - but I can't think of a better way to explain it.

我在工作簿中有一个公式，可以在比较驾车旅行时找到最便宜的价格.

I have a formula in a workbook that finds the cheapest price when comparing car journeys.

单元格C4至G4中包含价格.在单元格J5中，有一个公式可以找到这些单元格的最小值:[= MIN(C4:G4)].

Cells C4 to G4 have prices in them. In cell J5 is a formula to find the lowest value of these cells: [=MIN(C4:G4)].

一旦这是在J5中计算出来的，在它上面的J4中，我想执行一个名称查找(在C4到G4上方的行中的汽车公司名称)，该价格与找到的最便宜的价格有关吗?

Once this is calculated in J5, in J4 above it, I want to perform a name look-up (the car company names in the row above C4 to G4) that relates to this cheapest price found?

我将永远感激任何想法！

I would be eternally grateful for any ideas!

推荐答案

这有点猜测，但没有看到数据布局，但可以在J4中尝试.

This is a bit of a guess without seeing the data layout but try this in J4.

=INDEX($C$3:$G$3, , MATCH(J5, $C$4:$G$4, 0))

这篇关于返回单元格范围内的MIN值，然后从行中查找字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！