You can make the column number dynamic, but if you planning to combine two or more functions, why not use INDEX/MATCH in the first place. When used on large data sets, it can make your workbook slow. You can read my comparison of VLOOKUP Vs. INDEX/MATCH here. Here are some examples...