How can I use a table structured reference with a vlookup() function?
I want to use a structural reference in a vlookup function. I have a table called Staff_data on a separate sheet which I want to use as the table array. I've tried typing it in as worksheet reference![staff_data], hasn't worked. Do I need to name the range like I do for creating a dynamic dropdown or what am I missing? Thank you.