Ok I will try and explain this best I can.
I have created a drop down cell with 4 options to choose from.
So when they click on one of the options it fills out a column below with values from cells in another table elsewhere.
I can get it to do it for one of the options by having =if(m5=m2,d47,,) but when I try and make it so the cell changes if the if m5=m3,d48,,) it doesnt work how can I put it all in the same formula?
Thank
2007-03-23
00:07:48
·
2 answers
·
asked by
AndyCFCO
1
in
Software