alexisbr
asked on
Using Index/Match or other function to do the equivalent of vlookup when more than 255 characters in string
Hi. I am trying to do something fairly simple in Excel 2010 using Vlookup but ran into the 255 character limit. I checked posts online and found that index/match should work to do the same functionality without the 255 character limit but I am still getting an error.
I have attached my test Excel file but I also attached an image showing the sheet, as well as the formula displays.
testing_excel_vlookup_070518.xlsm
I have tried many iterations of index and match but I can't get this to work. Can anyone see what I am doing wrong?
Thank you!
Alexis
I have attached my test Excel file but I also attached an image showing the sheet, as well as the formula displays.
testing_excel_vlookup_070518.xlsm
I have tried many iterations of index and match but I can't get this to work. Can anyone see what I am doing wrong?
Thank you!
Alexis
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the great solution!
You're Welcome Alexis! Glad I was able to help.
ASKER
I appreciate your help.
Regards,
Alexis