View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JonathanW JonathanW is offline
external usenet poster
 
Posts: 18
Default 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