Jan 19, 2014 How to do a Vlookup in Microsoft Excel 2011 for Mac.
![Mac Mac](http://www.kristaveteto.com/wp-content/uploads/2012/11/11.png)
![Excel vlookup formula cheat sheet Excel vlookup formula cheat sheet](/uploads/1/2/5/4/125423624/793404217.jpg)
I'm using excel 2016 for mac and the vlookup function is returning incorrect data. I am looking up a series of sales figures by product by year by state (each identified by a unique code). If a data point doesn't exist (e.g., TX2014prod1), instead of returning an error, it pulls the data from the next line down (TN2014prod1). I have retyped the formula at least 10 times, deleted the sheet and started again and deleted the source data and restarted the spreadsheet. But each time, same error with vlookup. Any suggestions?