姓名公式 @ doppia2 :: 痞客邦 ::

Going to Work
LS Lowry 1959

輸入：1961、施、聰、郎

	A	B	C	D	E	F	G
1
2	輸入→	1961
3	辛丑
4	天運	土
5	壁上土
6
7						天格	10 癸水
8				施	9
9				聰	17	人格	26 己土
10		外格		郎	13
11		14 丁火				地格	30 癸水
12			總格	39 壬水

-----------------------------------------------------------

E7=IF(D7="","",VLOOKUP(D7,Sheet2!$B:$C,2,FALSE))
E8=VLOOKUP(D8,Sheet2!$B:$C,2,FALSE)
E9=VLOOKUP(D9,Sheet2!$B:$C,2,FALSE)
E10=IF(D10<>"",VLOOKUP(D10,Sheet2!$B:$C,2,FALSE),1)

G7=IF(D7="",E8+1,E7+E8)&" "& VLOOKUP(IF(D7="",E8+1,E7+E8),Sheet3!$B:$C,2,FALSE)
G9=CONCATENATE(E8+E9," ",VLOOKUP(E8+E9,Sheet3!$B:$C,2,FALSE))
G11=CONCATENATE(E9+E10," ",VLOOKUP(E9+E10,Sheet3!$B:$C,2,FALSE))

B11=IF(AND(D7<>"",D10=""),E7+E10,IF(AND(D7<>"",D10<>""),E10+E7,IF(AND(D7="",D10=""),2,IF(AND(D7="",D10<>""),E10+1))))&" "&VLOOKUP(IF(AND(D7<>"",D10=""),E7+E10,IF(AND(D7<>"",D10<>""),E10+E7,IF(AND(D7="",D10=""),2,IF(AND(D7="",D10<>""),E10+1)))),Sheet3!$B:$C,2,FALSE)

D12=IF(AND(D7<>"",D10<>""),E7+E8+E9+E10,IF(AND(D7<>"",D10=""),E7+E8+E9,IF(AND(D7="",D10<>""),+E8+E9+E10,IF(AND(D7="",D10=""),E8+E9))))&" "&VLOOKUP(IF(AND(D7<>"",D10<>""),E7+E8+E9+E10,IF(AND(D7<>"",D10=""),E7+E8+E9,IF(AND(D7="",D10<>""),E8+E9+E10,IF(AND(D7="",D10=""),E8+E9)))),Sheet3!$B:$C,2,FALSE)

A3=VLOOKUP($B$2,Sheet3!$F:$J,2,FALSE)
B4=VLOOKUP($B$2,Sheet3!$F:$J,5,FALSE)
A5=VLOOKUP($B$2,Sheet3!$F:$J,3,FALSE)