excel 엑셀 2007 vlookup 길게 사용 예 2003에서는 안됩니다.


=IF(MID(d2,9,1)="0",IF(NOT(ISNA(VLOOKUP((MID(D2,9,9)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,9)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,8)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,8)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,7)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,7)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,6)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,6)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,5)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,5)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,4)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,4)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,3)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,3)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),

IF(NOT(ISNA(VLOOKUP((MID(D2,9,2)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE))),VLOOKUP((MID(D2,9,2)),[ratetable.xls]rate!$C$1:$D$28925,2,FALSE),0)))))))),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,9)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,9)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,8)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,8)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,7)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,7)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,6)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,6)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,5)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,5)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,4)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,4)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,3)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,3)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),

IF(ISNUMBER(VLOOKUP(INT(MID(D2,9,2)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE)),VLOOKUP(INT(MID(D2,9,2)),[ratetable.xls]rate!$C$5:$D$28925,2,FALSE),False)))))))))