To me, Index and Match functions combined is so much better than VLookUp. But sometimes, that fact is better kept to myself rather than trying to convert others. Saves me a lot of headache.

Please, don’t get me started on XLOOKUP. Compatibility issues is a serious concern.

So, are you Team Index and Match or Team VLookUp?