Thanks Mandeep ji,
I do know that cell has a limit of characters, but my each returning value
has only 3 characters and max possible matches are 10 per lookup value, so
the maximum characters per cell would be 30. I guess that's not the issue
there.
Nevertheless, I would look into the alternate y
>
> Boss, First thing you should know is the Cell limit is limited,So in case
> Your the length of Concatenated lookup values characters is greater than
> cell limit it will turned out be #VALUE Error or The best one "MICROSOFT
> EXCEL IS NOT RESPONDING" :)
You can use a different approach/Ma
