vLookup Character Limit Error - Excel 2010 - Microsoft Community

Hi, You need to write your own VLOOKUP that doesn't have this limitation. ALT+F11 to open VB editor, right click 'ThisWorkbook and insert module and paste the code below in. Close VB editor and back on the worksheet call with the formula =MyVlookup(A1 ...

answers.microsoft.com