Why Use Index Match Instead Of Vlookup?
The main difference between VLOOKUP and INDEX MATCH is in column reference. VLOOKUP requires a static column reference whereas INDEX MATCH requires a dynamic column reference.INDEX MATCH allows you to click to choose which column you want to pull the value from. This leads to fewer errors. Why you should use INDEX match instead of […]