Watch the video above...
#NestedIF #Vlookup #Excel
As a part of Excel tips and tricks we have posted this video - Nested IF Vs Vlookup Vs Lookup, all three functions give similar results which you can learn and apply based on your comfortability.
Nested IF formula looks longer compared to Vlookup and #Lookup formula. Vlookup requires an array / table of conditions to return result. People who are finding difficult in using Nested IF formula then they may use Vlookup or lookup formula in Excel.
00:00 Introduction
01:03 Nested IF Function
02:51 Vlookup Function
05:08 Lookup function
06:36 Data Validation
08:35 Conclusion
Excel tips and tricks Playlist - https://www.youtube.com/watch?v=6xjqhQXHGMg&list=PLIo8gVJ3LwqhkLGdoyZWW1UTKUT2jGXHV
If you have any queries, please post it in comment section...
No comments:
Post a Comment