I'm trying to use an If statement to complete a form. I'm trying to pull the text from column c and insert the corresponding info into column d. for example: if the show is 'x' in column c, then insert 'theatre' in column d. However, because the text is coming from a drop down list in column c, i keep getting an error returned. There is no way to sort the shows in column c because they are arranged based on time, which also changes, not their title.
Any help you could provide would be greatly appreciated.
Thank you in advance,
Jeff
Bookmarks