Index and Match in Excel #exceltips #excel #funfacts

I’m loving using the Index and Match functions in place of Vlookup! How about you?

Formula Used: =INDEX(C6:C10, MATCH
(B2,A6:A10,0))

This tutorial has been sped up. Let me know if you prefer this pace or if you like the slower first version better.

#exceltips #excel #exceltutorials #funfacts #spreadsheet #sheets #exceltricks #learnexcel #exceltipsandtricks #howto #funfactofday #funfactsoftheday #learnmoreearnmore