Vlookup / updating a cell
 

Hi,
I am trying to update one cell (which is the lookup value of a vlookup) from
two other cells if either one of those cells change. I have a vlookup in one
sheet that calculates the price and in another sheet I have a calculator that
calculates the price.

I want to have more calculators that work out different things but use that
same info from the same price list vlookup. How do I create a cell (the one
that is the lookup value) that updates depending on not just one other cell

Vlookup / updating a cell
 

Not sure I understand completely, but as long as you have calculation
set to automatic, then VLOOKUP will recalculate whenever one of its
arguments changes. For instance:

=VLOOKUP(A1, B1:B100,2,FALSE)

will update if cell A1 or any cell in B1:B100 changes values. If B1
contains

=C1+D2

then the VLOOKUP will also change whenever C1 or D2 change, since that
change will cause a change in B1.

There are ways to force recalculation if other cells change, but it's
not necessary, nor is it useful, since the result of the VLOOKUP won't
be affected.


In article ,
JonathanW wrote:

Hi,
I am trying to update one cell (which is the lookup value of a vlookup) from
two other cells if either one of those cells change. I have a vlookup in one
sheet that calculates the price and in another sheet I have a calculator that
calculates the price.

I want to have more calculators that work out different things but use that
same info from the same price list vlookup. How do I create a cell (the one
that is the lookup value) that updates depending on not just one other cell