We are creating a CVS file to download to a roll forming

Customer Question

We are creating a CVS file to download to a roll forming machine using the available data from a wall panel design program. The wall panel design program has been customized to put the information into the right columns. But we need to add the location of the holes, and cutoff with a lengthy string of letters, and numbers. In addition the overall length of the stud needs to be added to the string.1st Question: Is there a "if then" or "lookup" formula that if I tell the program I need a 1 it pulls in the string from a chart.2nd Question: How can I pull in the length of the stud and attach it to the end of the string.

I have created a small example that answers both of your questions, in a very general sense. If you can attach your file, with one or two of the columns filled in, and then tell me where you want the functions to go I can get you an answer specific to what you need and explain it to you. It would probably help you to understand the functions better.