Correct me if I'm worng here. You want the header for the unit column to
display different units Kg, Pacel, ect. based on the value of cell D19 ? (In
a multiply choice test, I'd pick "week" as the one which belongs not in the
set)
Enter this in the header cell:
=IF(D19="Kg",I11,IF(D19="Pacel",D10,"No Unit"))

"OliveS" wrote:

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.