Way to overcome Excel Vlookup function limit of 256 characters

0 votes
I have an excel array that has numerous values. Some have more than 256 characters, while others have fewer than 256.

I was able to receive results when I used a sample string to perform a VLookup and it matched the rows with fewer than 256 characters. Rows with more than 256 characters return a "#N/A."

Is there a way for me to get around this limit using Vlookup or another built-in Excel function?
Sep 29 in Others by Kithuzzz
• 20,660 points
127 views

1 answer to this question.

0 votes

If you are using VLOOKUP like this:

=VLOOKUP(A2,D2:Z10,3,FALSE)

i.e. looking up A2 in D2:D10 and returning a result from F2:F10 then try this formula instead:

=INDEX(F2:F10,MATCH(TRUE,INDEX(D2:D10=A2,0),0))

Change ranges as required.

answered Sep 30 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
29 views
0 votes
1 answer

MAX function in Excel: is it possible to provide the range by means of variables?

Try this: =MAX(INDEX(A:A,B2):INDEX(A:A,B3)) READ MORE

answered Nov 15 in Others by narikkadan
• 37,660 points
24 views
0 votes
1 answer

Excel - function to convert first letter of each word to uppercase

there are two methods to do this: Method ...READ MORE

answered Nov 21 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

Excel stock and sales data management

you must attach the event handler each ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
64 views
0 votes
1 answer

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
48 views
0 votes
1 answer

Excel VLOOKUP where the key is not in the first column

INDEX/MATCH will do it in any direction of ...READ MORE

answered Oct 20 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP