Hi all,
I'm not sure what I'm doing wrong but I cannot get this vlookup to work. For reference, I'm using Excel 2016 for Mac (which I quietly suspect might be the issue but maybe I'm just being defensive!).
What I'm trying to do is return a text string associate with an account code. Here's my formula:
and here's my table array
Thank you in advance for your assistance!
Emily
I'm not sure what I'm doing wrong but I cannot get this vlookup to work. For reference, I'm using Excel 2016 for Mac (which I quietly suspect might be the issue but maybe I'm just being defensive!).
What I'm trying to do is return a text string associate with an account code. Here's my formula:

and here's my table array

Thank you in advance for your assistance!
Emily