A vlookup problem returning multiple matches

**stianabra** · 06-22-2009, 03:36 AM

I will try to explain this as good as possible. My problem is the following:

I am trying to connect a special date and a price to a special name (please see the attached file).

In sheet 1 I have the following:
- In column A I have a set of different names.
- In column B I have a set of different dates.
- In column C I have a set of different prices on bonds that off course refers to the different names at their respective dates.

In rest of the sheets I want an overview of the different bonds, and what their prices are at the exact date. The problem is that if I use the vlookup it is only the first value that will be extracted. How can I get all of the prices corresponding to the different dates to the correct bond.

I also want the possibility to update this every day.

Maybe this is hard to understand, but please take a look at the sheet and see if you understand this better.

Regards

**stianabra** · 06-22-2009, 08:11 AM

If you don't understand the problem, please tell were the confusing parts are and I will explain the problem in greater detail.

**NBVC** · 06-22-2009, 08:24 AM

See attached...

Formula in A5:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down as far as needed and across to next column

Note: If you adjust ranges, which you probably will need to, you need to reconfirm with CSE keys and copy down and across again.