VLOOKUP: IF VALUE NOT FOUND Return BLANK or ZERO

[@magicmic384]

Brilliant!! Thank you! I used your other videos to create something and got the N/A error. I knew it could be fixed but couldn’t remember how it was done..

[@laurenns1781]

you’re a lifesaver

[@derekoreborn]

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

[@frosty9392]

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

[@adzlisanatassia7733]

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

[@b.hemalathab.hemalatha1755]

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

[@webreid]

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

[@kathyadams5917]

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

[@amremam88]

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

[@catatansiraden5205]

Thanks a lot for the lesson. God bless you

[@SRCBags]

THANK YOU FOR YOUR VALUABLE INFORMATION

[@bridgetyonelamnyamana3334]

Thank you so much, you just saved my job

[@Giant_Soft]

Why do you use a comma when you use it, but it doesn't work for me unless I use a semicolon?

[@ign1teftw-318]

Can we use this is ict exam?

[@samuellal6116]

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

[@kaylaplummer2168]

SUCH a huge help! Thank you!

[@MuthalibAbdul-o5t]

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.

[@karenlynn7008]

This is exactly what I needed!

[@zeusdilip]

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

[@alonbedell7912]

Very Helpful, thanks

[@fairozhasan6450]

Solved my problem. Thank you so much 😀

[@seanshingatok303]

Thank you this helped a lot :)

[@redherring87]

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]

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

[@beatafras]

you have save my time

[@akashgorathoki0]

Thank you sir❤

[@dhunpagla3871]

Nice one

[@Sandman_OS]

This is great! Thank you!

[@Teesriflight]

Thank you Chester :)

[@dinu7214]

Thank you.,. Great help…

[@toootttgaming]

Thanks!

[@roryogorman1520]

SUPERB !! Thank you

[@annettefreeman8671]

Awesome! Thank you!

[@kyrstincote637]

Thank you!

[@livethedreaminspire461]

this helped

[@mahaganeshgunaratnam6075]

Thank you

[@nhl09rocks]

Thank you so much !!

[@tonyferreira6792]

Thank you so much.

[@rbzjewellersjignesh3803]

I am always getting 0 can you help me on this?

[@magicalfrijoles6766]

I followed the instructions and still have 0's. There must be a setting we are missing.

[@XCroxousX]

I love you!

[@gayathrisugunakumar5359]

Thank you

[@magicalfrijoles6766]

I used the xlookup and I still have all 0's.

[@LesterSuggs]

Helped me in 2024

[@acesiguenza4798]

Guys if you want to return the look up to Blank instead of 0, simply use if(vlookup(result)=0,"",vlookup(result)) u just need to think.