@ashielovestolearn
I looked up so many videos and it didn't work for me, but your tutorial worked as soon as I got the hang of it๐ฅบ thank you!
@sarahhawkins5339
Legend! I have looked this up so many times today and couldnโt figure it out, but I just tried your vid and it worked perfectly the first time ! Thank you!๐
@jahimuddin2306
I spent the entire video looking at the names.
@francescamendoza336
This was really helpful, thank you!
@jh.5687
Those names satisfy me to Live ๐. It's a life changing! ๐๐๐
@golchastrike1760
This was helpful! Also, I enjoyed reading the names ๐
@realjackeal
Wow I agree with the other comments. After watching other videos for many minutes, watched your video for a few seconds and it made a lot of sense lol. Thank you so much!
@chlkv
This is my fav and mostly used excel formula
@hydgurl77
Yessssss I'm one of them ๐ซฃ Love your videos..... very helpful! Thank you! Only request...please do something about the music in the background... it's loud and distracting. Please reduse the volume. Your new subscriber ๐
@jhonnmaicol6692
Awesome, thanks ๐
@ronroca4387
You saved the day
@nirmalrana9439
Nice.... awesome and short
@phandongexcel
Tรดi thรญch nแปi dung nร y
@tamiltamil8631
Iam learning with all xl work, thanks โค
@hixerion8388
You can do it even better, the thing is when you use absolute references of those specific cells you only stick to them, so in cases where extra rows are added, they will not be looked into. What you can do instead is reference the whole table as table array.
@Mystic5683
Why not use the built-in features of Excel by using structured tables and forget about the old fashion cell referencing using column and row references? Nobody uses old cell referencing since structured tables were introduced in 2007! V-lookup is a function that still exists, but it requires the look up column to be in the left-most column of your range. Since 2007, most people use the "INDEX + MATCH" functions together with structured table referencing. Look it up, it is much simpler and easy to troubleshoot, and if you ever change the structure of your table, the formulae are updated dynamically. In your example, if the ID column is not located on the far left ... OR ... If another column is inserted between the ID and Name columns ... OR ... if your list grows (another line added), then your vlookup formula has to be updated. With structured tables (table name = list), the formula would be =INDEX(list[Name],MATCH(B3,list[ID],0))... And never has to be changed.
@indunair4105
Soooo easyyyyyyyyyyyy.. Thanks session a ton
@3kings2625
Great tutorials.๐๐
@motivation_m00d
Great and helpful ๐
@katiebanks7460