Linking dates and values

S

seanbrown

I am trying to find the percent difference between two values. Eac
value is the last work day of the month. My spreadsheet lists dates i
column A and values in columns B-AI. How can I use the date to searc
for the relative value?
Thank
 
R

Ron Rosenfeld

I am trying to find the percent difference between two values. Each
value is the last work day of the month. My spreadsheet lists dates in
column A and values in columns B-AI. How can I use the date to search
for the relative value?
Thanks
Click to expand...

VLOOKUP

e.g.

=VLOOKUP(date or cell_ref containing date,A1:BI100,col_num_of_value,FALSE)


--ron
 
D

DNA

One way would be:

Percent Change
Δ%=100

100(x-y/y)

where x=new amount and y=base

so if x=150 and y=120

100(150-120/120) = 25%


HTH
 
Top