spill error in excel vlook formula

I had this issue and it turns out I had inadvertently put the lookup value/lookup array in the wrong order.
So wanted to lookup my TRADER in the range tblTraderLkUp and return the value from the third column.
I entered this (incorrectly):
=VLOOKUP(tblTraderLkUp,[@Trader],3,FALSE)

When I should have entered:
=VLOOKUP([@Trader],tblTraderLkUp,3,FALSE)

Doing this in Excel 2019 (ie putting the params in the wrong order) returns #VALUE! which makes the mistake more obvious.