View Single Post
  #1   Report Post  
Re2112
 
Posts: n/a
Default looking up value in chart

I am creating a worksheet and I need help with a formula. I have a chart 5
rows by 6 colums on page 1. On page 2, I have two colums that I will fill in
with which row and colum to use. How do I execute which row/collum to look in?
example:
a2 states the colum and a3 states which row. a4 would give the reference
value of both a2+a3. Thanks