Difference between VLookup & Sumif function. #vlookup #sumif #excel #shorts #excelshorts #exceltips

VLOOKUP vs. SUMIF: Which Excel Function Suits You Best?"

Hey Excel enthusiasts! Ever wondered about the difference between VLOOKUP and SUMIF functions? Let's dive in!

In our Excel sheet, we've got names and amounts, and we want to fetch amounts based on these names.

First up, VLOOKUP:
1. Type '='
2. Write 'VLOOKUP'
3. Select the name
4. Add a comma
5. Choose the range
6. Type '2,0' for an exact match
7. Hit enter.

Notice how VLOOKUP only fetches the first value for your selected name?

Now, let's try SUMIF:
1. Type '='
2. Write 'SUMIF'
3. Select the range of names
4. Add a comma
5. Choose the name
6. Add another comma
7. Select the range of amounts
8. Close the bracket and hit enter.

See how SUMIF adds up all duplicates of your selected name?

If you found this comparison helpful, smash that like button and subscribe for more awesome content! Let's Excel together! 🚀

Please like the video 🙏 and for more videos like this please subscribe our channel 🙏

Please join our telegram channel to download useful tools for Excel

#excel #exceltutorial #excelformula #shorts #shortsvideo #exceltips #msexcel #msoffice #excelshorts #excelformula #exceltricks #excelsupport #excelformulas #computer #formatting #vlookup #Sum

*********This video is for only educational purpose and it is not promoting any company or product*********