Vlookup limitation

  • Thread starter Thread starter Indhu
  • Start date Start date
I

Indhu

I have 2290 characters in a cell and need to compare using Vlookup. It throws
#value error. Is there any limitation on the number of characters it can
compare or is there any work around for this?
 
VLOOKUP() appears to stop working at 256 characters.
The work-around would be to make a User Defined Function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup character limitations 1
VLOOKUP Question 6
Searching the formula (not the value) for a text string 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Comparing the first 2 characters of a coloumn to a string 1
Dynamic col_index_num in VLOOKUP? 5
VLookup Help??? 2
VLookup 15

Back
Top