IFANDAA=Sheet2!AAAA=Sheet2!BBVLOOKUPlookup_value data1_rangecol_index_num range_lookup 函数改错
IF(AND(A:A>=Sheet2!A:A,A:A<=Sheet2!B:B),VLOOKUP(lookup_value, data_range, col_index_num, [range_lookup]), "")
原文地址: https://www.cveoy.top/t/topic/dHIX 著作权归作者所有。请勿转载和采集!