Vlookup limitation

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?
 
G

Gary''s Student

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

Searching the formula (not the value) for a text string 1
vlookup character limitations 1
Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Code character limit with Resize or Transpose or cell? 8
VLOOKUP Question 6
Default local file location - folder redirection slowness 0
Comparing two lists 0
Help With VLOOKUP 2

Top