Thread: Vlookup limitation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Vlookup limitation
VLOOKUP() appears to stop working at 256 characters.
The work-around would be to make a User Defined Function.
--
Gary''s Student - gsnu200804


"Indhu" wrote:

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?
Reply With QuoteReply With Quote