Excel Lookup Value from Another Column (in another sheet) with an Exact Match

Excel Lookup Value from Another Column (in another sheet) with an Exact Match

Ashley N Cameron

4 года назад

154,241 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@h.m.j9507
@h.m.j9507 - 13.11.2023 23:15

Really concise and well explained - thanks!!

Ответить
@mohamedgees148
@mohamedgees148 - 04.10.2023 22:10

Thank you so much.

Ответить
@anggelo7719
@anggelo7719 - 16.09.2023 19:05

THANK YOU!!!!

Ответить
@sosmimi8167
@sosmimi8167 - 17.08.2023 15:26

thanks ashley! you saved my day :D

Ответить
@Metztlim
@Metztlim - 15.08.2023 20:46

Amazing tutorial, you made it so simple. Thank you!

Ответить
@itspavan-yx7oe
@itspavan-yx7oe - 14.08.2023 10:40

Thank u so much, this video reduced my time in doing data migration 😊😊

Ответить
@user-gt2wj6bz8x
@user-gt2wj6bz8x - 22.06.2023 18:06

this worked wonderfully, in less than 90 seconds I solved an issue i've been hammering at for over an hour. Bravo !

Ответить
@monishad7040
@monishad7040 - 16.06.2023 13:01

Thank u

Ответить
@Nick_The_Remedy
@Nick_The_Remedy - 09.06.2023 00:35

YOU ARE MY HERO THANK YOU SO MUCH!!!!!!
-Grateful sales tax consultant

Ответить
@zayarwailin904
@zayarwailin904 - 07.06.2023 11:07

that is exactly what I was looking for, thank you so much

Ответить
@MeGaMaNEH
@MeGaMaNEH - 28.05.2023 02:55

Saved my life! Cheers.

Ответить
@pritamsingh8950
@pritamsingh8950 - 09.05.2023 12:33

Short and precise. Thanks!

Ответить
@chalapathi14
@chalapathi14 - 27.03.2023 17:05

It helped me alot. Thank you so much for your stuff.

Ответить
@zaydenrix5625
@zaydenrix5625 - 25.03.2023 18:42

Thank you, this video was extremely helpful

Ответить
@memapatravel769
@memapatravel769 - 07.03.2023 11:37

I love you, Thanks <3

Ответить
@AmySmith-yc8vu
@AmySmith-yc8vu - 17.02.2023 04:15

So helpful. Thank you for not overcomplicating something so simple!

Ответить
@skofovacha
@skofovacha - 18.01.2023 02:41

Thank you, so much !

Ответить
@raznjadee3390
@raznjadee3390 - 28.12.2022 14:25

Best❤

Ответить
@user-vc1cm3rh7e
@user-vc1cm3rh7e - 21.11.2022 19:57

This really helped me.

Ответить
@troyg1649
@troyg1649 - 05.11.2022 08:11

Thank you

Ответить
@nhcan92
@nhcan92 - 15.10.2022 19:29

Thanks. How can you find the position (row and column) of a text from other sheet ?

Ответить
@kaushalkumarllc
@kaushalkumarllc - 09.09.2022 01:27

Saved me ton of work. Thank You.. I love you

Ответить
@michiver
@michiver - 19.08.2022 20:51

Super clear and helpful! Thank you!

Ответить
@ron200388
@ron200388 - 22.07.2022 12:28

Thank you, I've watched numerous other videos that were much longer trying to explain this function. This one is short and sweet and gave me everything I needed.

Ответить
@oghenefejiroagbi1469
@oghenefejiroagbi1469 - 22.07.2022 08:24

This was very helpful, I watched this video in one minute before I had to submit a report. And now I'm already vlookup-ing like a pro.
PS that iferror part was helpful because i struggled with that before I finished the rest of your video.

Ответить
@danmurrphy3894
@danmurrphy3894 - 10.06.2022 20:56

Best simple explanation so far really appreciate your video and sharing!!

Ответить
@rohithv2198
@rohithv2198 - 16.05.2022 19:00

Really helpful. Thanks for the explanation.

Ответить
@veerapratap1948
@veerapratap1948 - 07.05.2022 03:31

If we are already mentioning A2, B17...why should we again mention 2?
Will it not be able to count the number of columns from A, B, etc.?
P.S. - I don't know almost anything bout Excel :)

Ответить
@dlnorman032195
@dlnorman032195 - 22.04.2022 07:38

THANK YOU!!!

Ответить
@messagehadi5942
@messagehadi5942 - 19.04.2022 21:34

Thank you so much for sharing this info, it is very helpful. One question, what formula or function should be entered if there is a "Product ID" in User tab, but for which there is not "Product name" or cell is blank in products tab. I had similar case and it returned value zero. How can I get rid of this zero.

Ответить
@dhruvilpatel856
@dhruvilpatel856 - 02.04.2022 06:04

You are a savior!

Ответить
@LorJayGmailcom
@LorJayGmailcom - 06.03.2022 21:48

Very clear explanation, you save me hours of work. It is appreciated.

Ответить
@AshishKumar-sz2xh
@AshishKumar-sz2xh - 03.03.2022 07:51

Thanks Ashley, you have solved my big problem.

Ответить
@matthewanacleto7885
@matthewanacleto7885 - 11.02.2022 01:30

Will the table grow?

Ответить
@padmavathivattikonda6303
@padmavathivattikonda6303 - 01.02.2022 05:32

Thank you so much !! It’s really really helpful for me

Ответить
@maryanneohlhoff7231
@maryanneohlhoff7231 - 27.10.2021 02:43

Very helpful! Thank you and God bless you.

Ответить
@rc4652
@rc4652 - 22.10.2021 23:28

That's awesome! Thanks for explaining this so concisely and really well!

Ответить