Referencing a column by column title

Hello! I'm new to excel so bare with me.

I am trying to find a way to reference to a list of names on one sheet, and then have a column of data taken from underneath those names on another sheet. So, I have a sheet I'm making that references to two other sheets. Sheet 1 has a list of titles, let's say: A, E, F, Q and R. Sheet 2 has a bunch of columns full of numbers headed by these titles (not just these titles though, all of the titles: A, B, C, D.....). I want the sheet I'm making to know which titles are on Sheet 1, and then pull the corresponding columns from Sheet 2 that match those titles, sort of like creating a new Sheet 2 that discards anything not listed on Sheet 1. I've been trying to figure out a way to do this but am falling short. Any pointers would be helpful.

You should be able to use INDEX(range,MATCH(row),MATCH(column)) to do this. If you need more help then it would be useful to attach a sample workbook which can describe your problem more fully.

Hope this helps.

Pete

Thanks a lot! I was able to alter this for use in my workbook. I was just wondering, what does row_num being COLUMN() signify? I had to change it to ROW() so tha the referenced columns would list in a column instead of a row, but I'm still not sure why exactly.