Sorry Duncan, but I'm having trouble interpreting what you're after.
If you are trying to return the Product Number that relates to a
certain pair of entries in C1 & C4, then you could use a formula like
="EV-R"&C1&"-"&C4 .
If you want to know whare that Product Number comes in the list of
Product Numbers, then you could use a formula like
=MATCH("EV-R"&C1&"-"&C4,ListRange,0) , where ListRange relates to
your list of Product Numbers.
But if you want something else, then I need further explanation ...
hth
ScottO


"Duncan" wrote in message
...
| 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.