Excel Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"))
 
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.
 
Back
Top