HI,

I have a dataset in one work sheet. The data, cells, can be lovated by
three identifiers. Each column has an identifier (month) and each row
have two identifier that has to combined. Region and Year.
Below is an example that shows the layout of the data.

* 1 2 3 4*
*101 2001* 1.81 2.27 5.03 1.6
*101 2002* 2.27 2.11 3.72 4.09
*101 20*03 2.26 3.24 3.23 2.65
*101 2004* 2.06 1.79 2.38 4.59
*101 2005* 4.01 2.37 3.65 5.16
*102 2001* 1.21 1.92 0.81 4.4
*102 2002* 0.57 1.33 1.85 3.3

How can write a formula/macro where I can put the three identifiers and
retrive the data/cell into a new work sheet?

Thanks in advance
Stefan


--
stefan7219
------------------------------------------------------------------------
stefan7219's Profile: http://www.excelforum.com/member.php...o&userid=27173
View this thread: http://www.excelforum.com/showthread...hreadid=466862