Linked Questions

Popular Questions

Not referencing column on excel table

Asked by At

I'm not sure what I am missing, but it's a recurring problem for me. I want to reference a column in a table, usually for an index function, but I also have this issue with vlookups. Its an issue with indicating the column I want to get info from. I'm sure I have the syntax wrong, but from researching, I don't appear to.

I am trying to get the data from the second column in a table in the workbook. It's on a different worksheet. The formula refers to the correct table and the column indicated in the match function returns the correct row number. When I try to reference the column I want by table referencing, I get a reference error. Please tell me what I am missing.

This returns a reference error:


This returns the correct data:


Please note that all of the following have been attempted but also return a reference error:


Related Questions