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