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:

=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),Intake[Begin])

This returns the correct data:

=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),2)

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

=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),Intake[@Begin])
=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),Column(Intake[Begin]))
=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),Intake[[#Data],[Begin]])
=INDEX(Intake,MATCH(C3,Intake[Helpercolumn2/SID],0),Intake[[#All],[Begin]])

Related Questions