=IF(B6="青龍","朱雀",IF(B6="朱雀","勾陳",IF(B6="勾陳","螣蛇",IF(B6="螣蛇","白虎",IF(B6="白虎","玄武",IF(B6="玄武","青龍","X"))))))
=IF(B7="青龍","朱雀",IF(B7="朱雀","勾陳",IF(B7="勾陳","螣蛇",IF(B7="螣蛇","白虎",IF(B7="白虎","玄武",IF(B7="玄武","青龍","X"))))))
=IF(B8="青龍","朱雀",IF(B8="朱雀","勾陳",IF(B8="勾陳","螣蛇",IF(B8="螣蛇","白虎",IF(B8="白虎","玄武",IF(B8="玄武","青龍","X"))))))
=IF(B9="青龍","朱雀",IF(B9="朱雀","勾陳",IF(B9="勾陳","螣蛇",IF(B9="螣蛇","白虎",IF(B9="白虎","玄武",IF(B9="玄武","青龍","X"))))))
=IF(B10="青龍","朱雀",IF(B10="朱雀","勾陳",IF(B10="勾陳","螣蛇",IF(B10="螣蛇","白虎",IF(B10="白虎","玄武",IF(B10="玄武","青龍","X"))))))
=VLOOKUP(VLOOKUP(H1,base!A:T,20,FALSE),data!FH1:FI10,2,FALSE)
↑
cell B10
我是過來人,提示: 這樣可減少 lookup 運算
合併對將來運算 & 複製 會造成障礙,如:B32, 33