I believe I have also captured the content in this post. I would suggest you to take a look at my another post “Pay attention when concatenate” when you are using CHOOSE with & in order to perform to vlookup.