Hello,
I have made an excel to illustrate what i want to do.
In the two grey fields in Column B & C, I want to retrieve the value in the rows "Investment I, Investment 2 & Investment 3" at the respective date, which is shown in the row under it.
I've tried using the LOOKUP formula as you can see without success. Also I dont know how to include the triple condition of 3 different investments for 3 different dates....
Can anyone aid me in this?
/Peter
Bookmarks