What error message do you get?

--
Regards
Roger Govier

"Noepie" wrote in message
...
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