Linking dates and values
 

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


--
seanbrown
------------------------------------------------------------------------
seanbrown's Profile: http://www.excelforum.com/member.php...o&userid=26514
View this thread: http://www.excelforum.com/showthread...hreadid=397820

On Mon, 22 Aug 2005 11:47:58 -0500, seanbrown
wrote:


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

VLOOKUP

e.g.

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


--ron

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