looking for a keyword/function name/example

M

MDBJ

I'm hoping this is basic, and someone can just give me a one shot example

I have a worksheet, the first col going down are dates 2nd col are prices
A B
1 4/21/06 20$
2 4/22/06 30$
3 4/23/06 20$


on another worksheet, I want to ask for a date to start and finish.
I know that my end date-start date = total# of dates,

if my start date input = 4/22/06 than I subtract 38098 (excel date for my
date in A1 ) from 38099 (date for 4/22)
now- how do I refer to cell B2 and forward until I've reached the end of my
# of dates,

I.E. in this case I want to reference cell B2 based on a formula-- I need
the number part of
the reference to B1/b2/b3 to changed based on the value of startdate-38098

damn, that isn't making sense to me..

if the start date is typed as 4/21/06- I convert and find it's zero nights
diff between my range and choice, so I want to pull prices from b1
if the start date is typed as 4/22/06- I convert and find it's one night
diff between my range and choice so I want to pull prices from b2
if the start date is typed as 4/22/06- I convert and find it's two nights
diff between my range and choice so I want to pull prices from b3

how do I choose my ref cell# based on math calcultions?

thanks for any pointers or function names I need to look at..
 
P

Pete_UK

Ok, use the Help Index to look up the INDIRECT( ) worksheet function -
that's how you can reference cells based on some calculation.

Hope this helps.

Pete
 
Top