Using VLOOKUP for more than 1 column

No need for VBA, I think. Try this. if this ISN'T what you need, please upload a sample file.

Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon