I am using VLookup to have a formula change on my spreadsheet based on the
value of the data validation list that is selected.

How do I have the cells populate with the actual formula and proper cell
references instead of the value of the cell holding the formula (which is
currently "#VALUE!" because it is meant just as a holder, not a cell that
needs a proper vale)

Some Background:
The spreadsheet is designed to calculate water discharge in rivers. A
series of measurements are taken then averaged for the final result. To
determine the velocity of the water at each measurement point the formula
will need to reference the Time and Revelution cells for that measurement.
Each set of measurements is done by using a single Measureing Meter, for wich
the formula is different for the various meters. I would like to have it
so that when a user selects the meter used from the Data Validation list I
created, It automatically populates the velocity cell for each measurement
point with the propper formula, maintaining the relative cell references.

Currently I can only get it to poulate with the final Value of the formula
cell it finds through VLOOKUP.

Meter list is at B5, The formula will populate around 20 measurement points
(varies per site)

Thanks for all your help!!
Daiv.

I'm not quite sure I understand, but maybe you can change your =vlookup()
formula to not show anything if the cell hasn't been completed.

=if(a1="","",vlookup(a1,sheet2!a:e,3,false))



Daiv wrote:

I am using VLookup to have a formula change on my spreadsheet based on the
value of the data validation list that is selected.

How do I have the cells populate with the actual formula and proper cell
references instead of the value of the cell holding the formula (which is
currently "#VALUE!" because it is meant just as a holder, not a cell that
needs a proper vale)

Some Background:
The spreadsheet is designed to calculate water discharge in rivers. A
series of measurements are taken then averaged for the final result. To
determine the velocity of the water at each measurement point the formula
will need to reference the Time and Revelution cells for that measurement.
Each set of measurements is done by using a single Measureing Meter, for wich
the formula is different for the various meters. I would like to have it
so that when a user selects the meter used from the Data Validation list I
created, It automatically populates the velocity cell for each measurement
point with the propper formula, maintaining the relative cell references.

Currently I can only get it to poulate with the final Value of the formula
cell it finds through VLOOKUP.

Meter list is at B5, The formula will populate around 20 measurement points
(varies per site)

Thanks for all your help!!
Daiv.

--

Dave Peterson

My problem is that it takes the value of the formula and puts it in the
velocity column instead of the formula itself. for example, if the formula
was =(5+3), the velocity column would be populated with 8 not =(5+3). in
this example it wouldn't make a difference. but I need to referemce cells of
changing numbers. so if the formula was =(A4+3), the value of my velocity
cell should be the relative cel to A4, +3 (perhaps B5=3, or V3+3), and the
refferenced cell value will be different for each measurement point.

My spreadsheet looks like this:
DISTANCE WIDTH DEPTH REVS TIME VELOCITY AREA DISCHARGE NOTES

1.00 1.000 0.00 0 40.0 #VALUE! 0.000 #VALUE!
2.00 1.000 0.00 0 40.0 0.006 0.000 0.000
3.00 1.000 0.00 0 40.0 0.006 0.000 0.000

for each row, the formula will be applied to the Velocity cell and will
reference the respective REVS and TIME cells.

Does this help clarify?

"Dave Peterson" wrote:

I'm not quite sure I understand, but maybe you can change your =vlookup()
formula to not show anything if the cell hasn't been completed.

=if(a1="","",vlookup(a1,sheet2!a:e,3,false))



Daiv wrote:

I am using VLookup to have a formula change on my spreadsheet based on the
value of the data validation list that is selected.

How do I have the cells populate with the actual formula and proper cell
references instead of the value of the cell holding the formula (which is
currently "#VALUE!" because it is meant just as a holder, not a cell that
needs a proper vale)

Some Background:
The spreadsheet is designed to calculate water discharge in rivers. A
series of measurements are taken then averaged for the final result. To
determine the velocity of the water at each measurement point the formula
will need to reference the Time and Revelution cells for that measurement.
Each set of measurements is done by using a single Measureing Meter, for wich
the formula is different for the various meters. I would like to have it
so that when a user selects the meter used from the Data Validation list I
created, It automatically populates the velocity cell for each measurement
point with the propper formula, maintaining the relative cell references.

Currently I can only get it to poulate with the final Value of the formula
cell it finds through VLOOKUP.

Meter list is at B5, The formula will populate around 20 measurement points
(varies per site)

Thanks for all your help!!
Daiv.

--

Dave Peterson