I am attempting to use the following formula but am getting a #NAME? error but I am not sure what my error is. The value cell T53 is a letter code and there are dollar values in cells E68 to E70. Any help would be appreciated.
=IF(T53=SC,V53=E68,IF(T53=CIR,V53=E69,IF(T53=so,V53=E70)))