Book3.xlsxThank you GeneralDisarray
I'm not getting it quite right - maybe because I am using values from another field so references as opposed to hard coding values in the formula
I've attached the doc
Formula - =CHOOSE(1+($C$13=$B$9)*($C$14=$Y$1)*1+($C$13=$B$9)*($C$14=$Y$2)*2+($C$13=$B$9)*($C$14=$Y$3)*3,"","+$X$1","+$X$2","+$X$3") -- this would be extended to have 9 combinations once working
Bookmarks