Excel-匹配，查找或索引 [英] Excel - Match, Lookup or Index

问题描述

确定这是一个简单的问题，但是所有公式-Lookup，Match，Index等之间都感到困惑.

am sure this is an easy question but getting confused between all the formulas- Lookup, Match, Index etc.

我有2张纸-SOW Actuals和RAW Project data.

在SOW Actuals的N列中，我具有要在Raw Project data的单元格A2:A60中找到的值.
当公式找到一个值时，我希望它返回Raw Project data中同一行上的列G中的值.

In column N of SOW Actuals I have the values I am trying to find in cells A2:A60 of Raw Project data.
When the formula finds a value I want it to return the value from column G on the same row in Raw Project data.

推荐答案

INDEX和MATCH比VLOOKUP更有效，更灵活.对于您的情况，请尝试:

INDEX and MATCH are more efficient and flexible than VLOOKUP. In your case, try:

=INDEX('RAW Project Data'!$G$2:$G$60,MATCH('SOW Actuals'!$N1,'RAW Project Data'!$A$2:$A$60,0))

这篇关于Excel-匹配，查找或索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！