I need to create a custom excel 2007 function that does the following:
case value in columnA ='Tech' output=columnB concatenated with columnC
case value in columnA ='Session' output=columnD concatenated with columnE
case value in columnA ='Poster' output=columnF concatenated with columnG
Basically based upon the value in column A I will be concatenating 2 other columns for the output
Whatever column I run this function in should always reference the value in column A for that row.
Can anyone supply some basic code samples that I can try?