TryCF Gist

trycf-gist-1532095958808-f222d946-419a-ef0c-e5ab-f9ca3da7e368.cfm

<cfscript>
excelColumnList = 'YR,MNTH,ANNIV,FIRST NAME,LAST NAME,EMAIL,NOTES';
mappedColumnList=  ',,,YEAR,MONTH,,First Name,Last Name,Email,COMMENTS';  
mappedColumn= 'Last Name';    

while(left(mappedColumnList,1)==",") {
  mappedColumnList = right( mappedColumnList,(len(mappedColumnList)-1) ) ;
}

local.index = ListFindNoCase(mappedColumnList, mappedColumn,',', true);

local.returnValue = ListGetAt(excelColumnList,local.index,",",true) ;

writeDump(local.returnValue);
</cfscript>