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