Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
with the MATCH function above to make it dynamic. =VLOOKUP(K8,B4:E13,MATCH("Sales Person",B3:E3,0),FALSE) Now, the VLOOKUP formula will give the same result even if the index of the Sales Person column is changed. Below is the final DsExcel code to show the usage of the MATCH function with the