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, 2022 in Others 3,345 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, 2022 by
• 63,720 points

0 votes
1 answer

## Is there a way to use LOOKUP/VLOOKUP/HLOOKUP to return headers in EXCEL. Current formula returning wrong value

Try this: =SUMPRODUCT(--(Schedule!\$B\$3:\$F\$7=A3)) READ MORE

0 votes
1 answer

## How to use VLOOKUP function in MS Excel

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

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

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

0 votes
1 answer

## Excel stock and sales data management

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

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

0 votes
1 answer

## Convert three letter country codes to full country names

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

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

0 votes
1 answer

## Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

0 votes
1 answer

## Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE