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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.