I want to allow a workbook reviewer to review each of three different scenarios by typing the numbers 1, 2, or 3 into a cell in order to populate a table of data from three data sets.
My first instinct was to use conditionals:
=if(C3=1,B2,0),if(c3=2,C2,0),if(c3=3,D2,0)
While I see the logic...