Im using a switch function to bring values from rows of data.
At the moment I have to quote each cell for example: SWITCH(expression,value1,result1,value2,result2, my actual expression has 15 values and results in the switch and is likley to grow.
Id like it to be just two ranges for example SWITCH(A1,B1:C1,B2:C2), or even two lists but I cant seem to ge either working