TryCF Gist

trycf-gist-1532094798427-da028270-5d47-d41b-7659-22674ea17beb.cfm

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

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

local.returnValue = "";

if ( local.index > 0 )

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

writedump(local.returnValue);

</cfscript>