excel函数获取另一个单元格的值 [英] excel function to get value of another cell
问题描述
描述问题的图像http://img215.imageshack.us/img215/3725 /20100314235127schedule2.jpg
I hope the image above can explain what I need. :)
问题1:获取行中第一个值的日期
Problem 1: Get the date where it is the first value in the row
问题2:获取值为100的日期
Problem 2: Get the date where the value is 100
我还会附加实际的excel文件
,但我只限于发布1个链接。
I would also attach the actual excel file, but I am limited to posting only 1 link.
推荐答案
左侧蓝色单元格的功能:
Function for left blue cell:
= IF(COUNTIF(L11:BJ11, > 0),INDEX($ L $ 2:$ BJ $ 2,MATCH(TRUE,INDEX(L11:BJ11> 0,0),0)), )
=IF(COUNTIF(L11:BJ11,">0"),INDEX($L$2:$BJ$2,MATCH(TRUE,INDEX(L11:BJ11>0,0),0)),"")
右侧蓝色单元格的功能:
Function for right blue cell:
= IF COUNTIF(L11:BJ11,100),INDEX($ L $ 2:$ BJ $ 2,MATCH(100,L11:BJ11,0)),)
=IF(COUNTIF(L11:BJ11,100),INDEX($L$2:$BJ$2,MATCH(100,L11:BJ11,0)),"")
这篇关于excel函数获取另一个单元格的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!