No video :(

VLOOKUP: IF VALUE NOT FOUND Return BLANK or ZERO

Подписаться 102 тыс.

Просмотров 149 тыс.

50% 1

This video demonstrates how to return a blank or zero in place of an NA error when performing a VLOOKUP.
This video will be useful if you are asking the following questions:
How do I get a VLOOKUP to return blank if a value is not found?
How to get a VLOOKUP to return blank instead of 0 or n/a in excel?
------------------------

Опубликовано:

8 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@adzlisanatassia7733 2 года назад

This is what I looking for! Thank you very much for this HUGE help! God bless you.

@webreid 2 года назад

Did exactly what I was looking for, thank you for putting this up.

@amremam88 Год назад

That's exactly what I've been looking for, God bless you 🙏

@catatansiraden5205 3 года назад

Thanks a lot for the lesson. God bless you

@kaylaplummer2168 3 года назад

SUCH a huge help! Thank you!

@derekeano 10 месяцев назад

Great video! Excellent Snape-sounding teacher (I mean that as a compliment, Snape was a badass and a good guy!) Cheers from America

@laurensturdivant1781 3 года назад

you’re a lifesaver

@samuellal6116 3 года назад

Thank you so much for this video, it helps me lot once again thank you so much, God bless you

@karenlynn7008 2 года назад

This is exactly what I needed!

@alonbedell7912 3 года назад

Very Helpful, thanks

@fairozhasan6450 Год назад

Solved my problem. Thank you so much 😀

@sander_t 2 года назад

This is great! Thank you!

@bridgetyonelamnyamana3334 16 дней назад

Thank you so much, you just saved my job

@frosty9392 2 года назад

mic made it a little hard to hear you, but perfectly answered my question. thank you!

@annettefreeman8671 2 года назад

Awesome! Thank you!

@dinu7214 7 месяцев назад

Thank you.,. Great help…

@roryogorman1520 8 месяцев назад

SUPERB !! Thank you

@seanshingatok303 8 месяцев назад

Thank you this helped a lot :)

@nhl09rocks 2 года назад

Thank you so much !!

@tonyferreira6792 2 года назад

Thank you so much.

@Teesriflight 2 года назад

Thank you Chester :)

@toootttgaming 2 года назад

Thanks!

@kyrstincote637 Год назад

Thank you!

@livethedreaminspire461 10 месяцев назад

this helped

@mahaganeshgunaratnam6075 2 года назад

Thank you

@b.hemalathab.hemalatha1755 3 года назад

i got empty cells in reference cell so it does return Zero but i need those are return blank instead 0

@dhunpagla3871 4 года назад

Nice one

@kathyadams5917 2 года назад

This helps some, but how do you do this between 2 sheets???

@beatafras 6 месяцев назад

you have save my time

@ign1teftw-318 Год назад

Can we use this is ict exam?

@XCroxousX 2 года назад

I love you!

@zeusdilip 2 года назад

If i want to print the same data in the #N/A what should i give

@user-fv9pq8yf3u 9 месяцев назад

this helps but what if we want a blank value instead of zero, like if this column is a date, its gonna give a value of 01/01/1900.

@redherring87 3 года назад

i have a spreadhseet that has other cells that calculate totals of cells that the vlookup would return info. The problem i am running into is that i'm trying these NA shortcuts but when i return BLANKS from Vlookup... my other cell that is trying to add up for totals now has a VALUE error. Any ideas on why this is happening?

@toootttgaming 2 года назад

When the value its true it will show your value, IFERROR(value true, value false)