Microsoft Office Questions? Ask a IT Expert for Support ASAP
Please paste the vlookup formula here so I can try to fix it for you
Here you go
Thank you for rating this answer "Excellent" or "Good" If I was able to answer your question so I get credit for my work
Apparently you are using an old version of Excel (2003 or older). Correct?
It should work in Excel 2011 for the Mac!
Please send me the file so I can see the data you're trying to pull
Ok go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
That file is indeed an Excel 2003 file (xls format). I will give you another formula that will work for 2003 but for what the question is worth and the time being spent on it you need to rate the answer as the issue was not in the formula that I gave you
Ok here is the file with the modified formulas in the yellow cells
Hope this is ok. Let me know if you have any questions