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