=IFERROR(VLOOKUP(A2&B2,IF({1,0},G$2:G$108&H$2:H$108,I$2:I$108),2,FALSE),0)
输入完成后,按Ctrl+Shift+Enter,得到
{=IFERROR(VLOOKUP(A2&B2,IF({1,0},G$2:G$108&H$2:H$108,I$2:I$108),2,FALSE),0)}
=IFERROR(VLOOKUP(A2&B2,IF({1,0},G$2:G$108&H$2:H$108,I$2:I$108),2,FALSE),0)
输入完成后,按Ctrl+Shift+Enter,得到
{=IFERROR(VLOOKUP(A2&B2,IF({1,0},G$2:G$108&H$2:H$108,I$2:I$108),2,FALSE),0)}