lesley burlingham
Member
I need to have excel return a number for the following
C7 = "Daily Light My2014" and C11 = "Driveline" return number 2
C7 = "Daily Light My2014" and C11 = "Extra Driveline" return number 3
C7 = "Daily Medium" and C11 = "Driveline" return number 4
There will be 18 combinations . Bot sure if to use a nested if or if there is another option. I need the answer in Cell B14
C7 = "Daily Light My2014" and C11 = "Driveline" return number 2
C7 = "Daily Light My2014" and C11 = "Extra Driveline" return number 3
C7 = "Daily Medium" and C11 = "Driveline" return number 4
There will be 18 combinations . Bot sure if to use a nested if or if there is another option. I need the answer in Cell B14