What I'm trying to accomplish is this:
I have a customer field in C2. I'm trying to generate a specific hyperlink to different web pages in S38, based on the customer inputted into C2.
I tried using data to make a =Hyperlink(vlookup function, and it works. As I switch the customer name...