Vlookup / updating a cell

[Guest]

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

 

[JE McGimpsey]

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.