How to Do a VLOOKUP in Excel #4 : Using VLOOKUP for multiple columns(unordered) HD

In this video I teach how to use the VLOOKUP function when we have multiple columns which are unordered to be looked up using sample Human Resource data. Also used in a Match function to get the column index number dynamically when the order of the column differ from the Master table. Excel Workbook Download : http://fxnikee.com/fxexcel/vlookup-video-series-1-6/