本文介绍了Excel-匹配,查找或索引的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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

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

我有2张纸-SOW ActualsRAW Project data.

SOW ActualsN列中,我具有要在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.

推荐答案

INDEXMATCHVLOOKUP更有效,更灵活.对于您的情况,请尝试:

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-匹配,查找或索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-28 04:24