Hello,

I have the following issue. I have created two worksheets (ws). The first
one contains several individual bonds with in the adjacent columns price
information, yields, and so on. In the second one I have made a list
(validated) which refers to the list of bonds in the first ws. When I choose
a bondtitle in the second ws, I would like to get the price, yield and so on
which correspond to the chosen title in the adjacent columns. When I use the
following formula I get an error message:

=VLOOKUP($B9;Data!$A:$W;COLUMN(Data!Q18);FALSE)

$B9 = Bondtitle
Data!$A:$W=matrix (first ws)
COLUMN(Data!Q18) = column in first ws with the prices of the individual bonds

The matrix is not sorted, so I use the False component. Does anyone have a
clue why I get an error message.

Thanx.

Noepie