I want to use a formula to select from a list of products in a column that is
related to 2 variables eg if c1 = 2 and c4 = 400 then sum equals EV-R2-400.
The list of products relates to changes in Rx and -x eg
EV-R2-400 (cell S1)
EV-R8-800 (cell S2)
EV-R16-1000 (cell S3)
EV-R32-1600 (cell S4)
I can use this sum to select just one option, but cannot enlarge it
=IF(AND(c10,c1<5,c4=400),S1,0)
Any ideas, thanks.