Index/Match to return values to compare

Help please -using excel 2010 I cannot work out how to put in place the following.

I want to enter values for various investments on different dates I.e. each column to have a date heading and each row / record to have a fund and the value for the column date. I then want to select 2 columns to compare

So my table would be something like this:

Investment. 1 jan 2012. 1 feb 2002. 1 mar 2002

Inv 1. 10,000. 12,000. 13,000
Inv 2. 1,000. 1,500. 2,000
Inv 3. 500. 600. 700


With the above I then want to select say 1 jan and 1 mar and work out the % change say in a new table or a separate worksheet. Or I may want to select 1 feb and 1 mar. How would I do this?

Welcome to the forum. I'm surprised that the moderators have not asked you to change your thread title.

You could use INDEX/MATCH/MATCH to return values for investment/date pairs and then compare them.

When you change your thread title, please post a sample workbook.

Regards, TMS

Iptgfs,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Hi Iptgfs

See the attached, would this be what you require!

In B13, copy across and down:

Formula:

Please Login or Register  to view this content.

And the cells F13:F17 formatted as "0.00%;[Red]-0.00%;;"

@Kevin: thanks for stepping in. Put this on the back burner and then clean forgot about it. Your solution looks exactly like what I had in mind. Thanks again, TMS

@ TMShucks

No problem.