I have a reference set in excel that is two columns. The first column lists
functions in text (i.e. AVERAGE, COUNT, COUNTA, MAX, MIN....). The second
column lists the corresponding function number (i.e. AVG = 1, COUNT =2....).
I made a drop down box using data, validation, list so that the function
numbers appear in a row. The row below I put in subtotal(grab command from
drop down, data set to calc). I can't figure out how to return the TEXT from
my columns above, rather than function number. I want my drop down to have
AVERAGE, not 1.