Simple VLOOKUP format question

[Expiry]

I have been out of the loop of using Excel for a while and I've been asked to look at some vlookup formulas.


VLOOKUP([@Name],Table2,2,0),""

What is going on with the [@Name] bit?

Name is the column name in the table that this formula is in. I understand that bit. If I over type Name in the column header, it is automatically reflected in this formula.

Can someone explain to me what the square brackets are for? I feel like I've stepped out of a time machine.

 

[Fluff]

Have a look here
https://support.office.com/en-us/ar...l-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

 

[Expiry]

Have a look here
https://support.office.com/en-us/ar...l-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

Perfect. Thank you.

 

[Fluff]

You're welcome