you’re a lifesaver

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

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

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

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

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

Thanks a lot for the lesson. God bless you

Thank you so much, you just saved my job

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

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.

Thank you.,. Great help…

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

you have save my time

SUPERB !! Thank you

this helped

Very Helpful, thanks

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

SUCH a huge help! Thank you!

This is exactly what I needed!

Solved my problem. Thank you so much 😀

Thank you!

Thank you

Thank you this helped a lot :)

Thanks!

Nice one

Thank you Chester :)

Thank you so much.

Thank you so much !!

Awesome! Thank you!

Can we use this is ict exam?

This is great! Thank you!

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

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?

I love you!

Helped me in 2024

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

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

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.

Thank you