第1个回答 2008-06-16
假设龙套在A列,岁数在B列,要输入的格在C列
公式:=vlookup(C1,$A:$B,2,0)
如果龙套和岁数的表与要输入格的表不是同一个工作表,前表是sheet1,后表是sheet2
公式:=vlookup(C1,sheet1!$A:$B,2,0)
第2个回答 2008-06-16
B1=IF(A1="龙套1","10岁","")&IF(A1="龙套2","14岁","")&IF(A1="龙套3","12岁","")&IF(A1="龙套4","13岁","")&IF(A1="龙套5","111岁","")&IF(A1="龙套6","134岁","")&IF(A1="龙套7","4232岁","")&IF(A1="龙套8","9999岁","")&IF(A1="龙套9","6767岁","")&IF(A1="路人甲","282岁","")&IF(A1="路人乙","222岁","")&IF(A1="路人丙","343岁","")
第3个回答 2008-06-16
=IF(ISERROR(VLOOKUP(sheet1!C1,Sheet1!$A$1,2,FALSE)),0,VLOOKUP(sheet1!C1,Sheet1!$A$1,2,FALSE))
A列姓名,B列年纪,C列是你另外的名字,然后下拉填充