Excel: Compare two columns using Vlookup

preview_player
Показать описание
The video offers a short tutorial on how to compare two columns in Excel using Vlookup.
Рекомендации по теме
Комментарии
Автор

This is a short but succinct explanation of vlookup. Thank you for making videos that don’t take 15 minutes to say something you can say in four.

suburbsforvernow
Автор

i was confused for days. and this 4 mins video saved my life

owadiary
Автор

Thanks mate. You just save my day! I watch your channel and Vanna Excel to solve my questions on my work!!!

jonchapman
Автор

Hello Prashant, thanks for your video, I'm working as a wave manager for a migration project. I've been hearing my colleagues talk about vlookup for the longest time and its only today that I studied it so I can work faster. Thanks again! :)

ericjancinal
Автор

thank you very much, first time could ever to use pivot inspite of having watch of 50 plus video, you saved thanks alot.

kyan
Автор

Lets say there is another employee named the same Nathan Hale but who is "not participating", then when using the formula, the vlookup formula will match with the first same data, the first Nathan Hale which is participating, so is there any way in which the data cannot be matched with another data which is already matched.

isak_zothansanga
Автор

How to sort the data if there are text columns and ", " then how to transpose and do vlookup

sarfarazalam
Автор

Thank you so much too short and quick learn.

SaradaShrestha
Автор

this videos teach me within 4mins only

mohamedfairusbinsamsudin
Автор

WHAT IF I WANT WHO ARE NOT PARTICIPATED ?

SaiKumar-ffld
Автор

Thanks for the video but here you have typed "1" for column reference as the range only has 1 column, that's something what was incorrect, other than that all good.

ishanbhardwaj
Автор

Your explanation of third argument "1" at 00:01:42 is wrong. It is one because you have only column in table array.

granand
Автор

Vaya vedio main to kuch dikh v nehi raha he . Kyun dale hoo🤦‍♀️

babitajena
Автор

Hindi m bol deta bhai ..jda acha smj aa jata 🙏

shubhampiplani
Автор

Video is good and informative, however, you are using the word "okay" far too many times and reducing the use of that world will improve the quality of your tutorial.

tai
Автор

Good video but you said OK about twenty times

tommyharris
Автор

Why are all these video producers from Pakistan? This guy's diction is SHOCKING and every second word is kay. FFS

zapkvr
Автор

OK!!!
I disliked it for OK!!!
Those who read this OK!!!

disha
Автор

Stop using "ok" so many times. It's irritating

pushpajadaw