Search in matrix.
 

Hi! I have a long list with three columns: Name, date and price. I also have
a matrix with dates as a column and names as rows. In every cell I have a
value corresponding to that particular date and name. What I want to do is to
get these values into my orginial list, ie I want to expand that list so that
is has 4 columns. But how do I get the values from the matrix to the list?
Any help appreciated!

Search in matrix.
 

See:

http://www.cpearson.com/excel/lookups.htm
--
Gary''s Student - gsnu200752


"Arne Hegefors" wrote:

Hi! I have a long list with three columns: Name, date and price. I also have
a matrix with dates as a column and names as rows. In every cell I have a
value corresponding to that particular date and name. What I want to do is to
get these values into my orginial list, ie I want to expand that list so that
is has 4 columns. But how do I get the values from the matrix to the list?
Any help appreciated!