Vlookup Vs Index Match Formula differences

AnnThompson ✭✭
edited 04/22/24 in Formulas and Functions

I have used a few sheets using the Vlookup formula and one using the index match formula for the same lookup, it is populating a column on in a sheet using the data in another spreadsheet. What is the difference? I have always used the reference formula, then recently a SS Help Desk person used the index match and I failed to ask him what the difference is. When would 'Reference' formula be used?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!