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 Computers & Internet ➔ Software
Sorry this isnt working, It just comes up with Value.....
How would I do a vlookup?
2007-03-23 00:27:39 · update #1
you have to put in "else" do like
if((m5=m2,d47), if(m5=m3,d48))
the common after the bracket stands for else also the amount brackets are very important because you have close all statements - these should show up colour for you so you know you have got them all!
2007-03-23 00:18:36 · answer #1 · answered by dollymixture 4 · 0⤊ 0⤋
It sounds as if you need to use a lookup function.
2007-03-23 07:12:25 · answer #2 · answered by Avondrow 7 · 0⤊ 0⤋