CODEWITHSUNDEEP
excelvlookup
user9819807
user9819807

Reputation:

vlookup function excel cut part of string

Guys i have a little problem. I have 2 csv files, i want to copy some data from one csv to another where id is the same. For this i use vlookupfunction but something is not good. The orginal string in orginal csv is:

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).

And when i use this function 

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

I get this string:

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).

The difference is that i have in orginal string this part and in the copied version i lose that part:

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

Can someone help me with this? Did i do something wrong in my function?

Upvotes: 0

Views: 45

Answers (1)

Michal
Michal

Reputation: 6054

Your version of Excel must be hitting the character limit of VLOOKUP. You should not be using this function in the first place, it's broken and it sucks. Consider using much superior INDEX/MATCH combination =index(osnova.csv!$H$1660, match($A2,osnova.csv!$B$2,0)).

Upvotes: 1

Related Questions