vlookup函数excel剪切部分字符串

Question

伙计们，我有点小问题。我有两个csv文件，我想将一些数据从一个csv复制到另一个id相同的csv。为此，我使用了vlookupfunction，但有些地方不太好。原始csv中的原始字符串为：

48 Port Managed Layer 3 Gigabit Ethernet Switch with optional 10GigE uplink and 802.3af and Legacy Power over Ethernet. Includes 48 - Copper Gigabit (1000Base-T) access ports and 2 - High Speed Expansion Slots. Provides up to 370 watts of 802.3af compliant power. Features include 802.1Q VLANs, GVRP, 802.1p QoS, 802.1w Rapid Spanning Tree, 802.3ad Link Aggregation, Auto MDI/MDI-X, CLI, HTTP GUI, SSH, SSL, RADIUS, SNMP. 19" Rackmount 1U housing. Includes AC PoE power supply. Supported expansion modules: Dual Stacking XIM (4700470F1, 4700470F2, 4700470F5), Dual SFP XIM (1700473F1), Dual SFP+ XIM (1700471F1).

当我使用这个函数时

=IFERROR(VLOOKUP($A2,osnova.csv!$B$2:$AD$1660,8,0),IF(G2="","",G2))

我得到这个字符串：

48 Port Managed Layer 3 Gigabit Ethernet Switch with optional 10GigE uplink and 802.3af and Legacy Power over Ethernet. Includes 48 - Copper Gigabit (1000Base-T) access ports and 2 - High Speed Expansion Slots. Provides up to 370 watts of 802.3af compliant power. Features include 802.1Q VLANs, GVRP, 802.1p QoS, 802.1w Rapid Spanning Tree, 802. 19" Rackmount 1U housing. Includes AC PoE power supply. Supported expansion modules: Dual Stacking XIM (4700470F1, 4700470F2, 4700470F5), Dual SFP XIM (1700473F1), Dual SFP+ XIM (1700471F1).

不同的是，我在原始字符串中有这一部分，而在复制版本中我丢失了这一部分：

.3ad Link Aggregation, Auto MDI/MDI-X, CLI, HTTP GUI, SSH, SSL, RADIUS, SNMP.

有人能帮我一下吗？我是不是在函数中做错了什么？

Answer 1

您的Excel版本必须达到VLOOKUP的character limit。你一开始就不应该使用这个函数，it's broken and it sucks。考虑使用大量的superior INDEX/MATCH组合=index(osnova.csv!$H$1660, match($A2,osnova.csv!$B$2,0))。