开发者

Microsoft Excel Using Match result

I have a drop down that I call match on. Can I directly incorporate matches result into a formula.

For example I am trying to say

=C(MATCH(J15,A1:A52,0))

I am using match to find the second component of the cells location. I am using Excel 开发者_StackOverflow2003.


=INDEX($C:$C,MATCH(J15,A1:A52,0))


=INDIRECT(ADDRESS(MATCH(I23,'State Sales Tax'!A2:A52,0)+1,3))
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜