# Returning a value by matching two dates

1. ## Returning a value by matching two dates

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

2. ## Re: Returning a value by matching two dates

Is this what you are looking for? For the sake of your scrolling finger, I hid rows 9:948. I used this formula
Formula:
`Please Login or Register  to view this content.`
If you would prefer zeros to blanks, replace "" with 0

3. ## Re: Returning a value by matching two dates

It's not very clear what you want, but try this formula in B9:

=IF(\$A9=B\$3,B\$2,0)+IF(\$A9=B\$5,B\$4,0)+IF(\$A9=B\$7,B\$6,0)

Note that you may need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Then copy it into C9, and then copy both formulae down as far as you need them.

Hope this helps.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)