Extracting cell or cells from a table

Hi guys,

I have a table with headers.

I want to pull out cells from this table and use them in another worksheet.

Because the table's ordering of headers may change, I want to look up cells by header value (column) and then by row.

To find the column is easy, I can do for example, "MATCH("symbol",george[#Headers],0)". My table is called "george" and the column header is "symbol", and that will return the relative column number of "symbol" inside a table called "george".

But now I also need the row. I want to get all the rows. So I want the column "symbol" and the rows 1, 2, 3, 4, 5 until all the rows of the table. So I can type this:

=INDEX(george[#All],2,MATCH("symbol",george[#Headers],0))

That will give me the first row (past the headers) inside "george", at the column "symbol".

This is great, but I have hardcoded "2" the row number.

When I copy this cell below, it does not automatically increase the "2" to "3" as it would do when you copy a cell below to other cells.

Can someone please help me?

Many thanks

I think you need dollar signs in your code to lock the column or cell numbers.