Variable content within a cell

Copper Contributor

Hi, I am working on getting a description into a cell that contains a sentence, website, and phone number. I am pulling the descriptions from a table with a vlookup. The website and phone number within the description can vary based on who it goes to. Those phone numbers and websites are contained in another grid. Is there a way I can pull one of the 20 phone numbers into the description for the 400 different people? Or do I need to create 20 different descriptions and have a little more complicated vlookup/if function?

0 Replies