Excel Function

[Guest]

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.

 

[Guest]

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"))

 

[Guest]

Think you could also try an INDIRECT(VLOOKUP(..)) construct
to return the contents of the cell reference

Assuming your list of DV selections / cell references are in A1:B4, eg:

kg I11
parcel D10
ton E10
week J11
etc

If the DV cell is D19, you could place in say, E19:
=IF(D19="","",INDIRECT(VLOOKUP(D19,A:B,2,0)))

E19 will return the contents of the corresp cell reference. Eg: if D19 =
parcel, then E19 will return the contents of D10, if D19 = ton, E19 returns
what's in E10, and so on.