ExcelBanter - Vlookup limitation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup limitation (https://www.excelbanter.com/excel-worksheet-functions/202151-vlookup-limitation.html)

Indhu

Vlookup limitation

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?

Gary''s Student

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?

All times are GMT +1. The time now is 05:43 AM.