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?
you’re a lifesaver
Thank you so much, you just saved my job
mic made it a little hard to hear you, but perfectly answered my question. thank you!
This is what I looking for! Thank you very much for this HUGE help! God bless you.
i got empty cells in reference cell so it does return Zero but i need those are return blank instead 0
Great video! Excellent Snape-sounding teacher (I mean that as a compliment, Snape was a badass and a good guy!)
Cheers from America
Thanks a lot for the lesson. God bless you
Did exactly what I was looking for, thank you for putting this up.
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.
That's exactly what I've been looking for, God bless you 🙏
Thank you.,. Great help…
This helps some, but how do you do this between 2 sheets???
you have save my time
Thank you so much for this video, it helps me lot once again thank you so much, God bless you
Very Helpful, thanks
SUPERB !! Thank you
this helped
SUCH a huge help! Thank you!
This is exactly what I needed!
Can we use this is ict exam?
Thank you
Solved my problem. Thank you so much 😀
Thank you!
Thank you Chester :)
If i want to print the same data in the #N/A what should i give
Thanks!
Nice one
Helped me in 2024
Thank you so much.
Thank you this helped a lot :)
Awesome! Thank you!
Thank you so much !!
This is great! Thank you!
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?
When the value its true it will show your value, IFERROR(value true, value false)
I am always getting 0 can you help me on this?
I followed the instructions and still have 0's. There must be a setting we are missing.
I love you!
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