One way ..

Assume column data (below the header row 3) is in rows 4 to 10

Select Y4:Y10

Put in the formula bar,
array-enter (press CTRL+SHIFT+ENTER):
=IF(TRIM(Y3)="","",OFFSET($K$4:$K$10,,MATCH(TRIM(Y 3),K3:W3,0)-1))

Y4:Y10 will return the column of data for the input in Y3

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kuansheng" wrote in message
oups.com...
Hi,

I have in column K through W, column of data . The column heading is in
row K3:W3. In cell Y3 is the heading of a new column that the user will
enter. What i need to do is to find the matching cloumn heading from
K3:W3 and copy all the data from that column to the new column. Anyone
can help me out. Any help is appriciated, thanks you.