Refer to a cell in another column within a table

We have a table, call it tblTable for now.

Once created, it has some blank cells in one of it's columns.

Using the code below I am finding each blank cell. I need the code to insert in the for-next loop to extract the first left 3 characters from another column in the same table, the other column's name is "Student".

Please Login or Register  to view this content.

I wish to do so by referring to the column's name ("Student") instead of other means like devising offset or any other way. I have been monkeying with left([Student],3) and left(tblTable[student],3) and left([@student],3) and left(tblTable[@student],3) (Obviously not having a clue as to what the "@" sign is for...) but I suspect most monkeys would have better luck than I did.

The easy part for me is left(blahblah, 3).

The hard part for me is just what is blahblah!

Can anyone help?

Thank-you both, very much for trying to help me!

The situation is along the lines that TMS offered, but I get a Run-time error of 1004 even when I broke it down to the most simple form, worksheet attached hereto-
1004.JPG

Why is this so elusive???

Thanks TMS; I really hoped there was a solution referring to a relative cell within a specific column I could stipulate, but if someone with your qualifications breaks back down to a strict offset solution, it is time to give up on a named column direction. I will just have to add in a variable and a find routine, as the incoming data on the sheet I import has the column with their names "move around"; I can not depend on it being in the same place but I can depend on it being named the same.

Thank-you.

I am going to try it out either tomorrow or Tuesday, but for now my head is aching, eyes are crossed and I don't know how some folks do this ALL the time...(!)

THANK-YOU!