Is someone could help me I would really appreciate it. I have a cell D19
that contains a validation text with 4 terms to choose from "kg", "parcel",
"ton" , "week"
I need a formula that can then enter the answers which of course are in the
heading of my estimate so when i choose "Kg" from D19 it will pick up the
cell I11, if I Choose "parcel" from D19, it will choose D10 which holds the
parcel number. I am used to using the IF function but because that is true
and false it wont work with so many variables... If any one can help me I
will be eternally grateful.