Enjoyed your video. Am having problems using the if function with the vlookup at the same time. Objecitve is to have clean worksheet if no data is input, instead of showing the "n/a" in the cell that contains a formula that awaits for data to be entered.
basically, my formula reads ( =if(e4>" ",vlookup(e4,hardware!$C$3:$M$104,2,0)," "). This formula works returns a blank cell but when I input data on e4, e5 remains blank!
What am I doing wrong. Do you have any videos that deals with this?
I love the way you nest those IF statments bro...nice and deep like
MrSanjeevsinghsahota 4 weeks ago 2
thanx man
khaman8 1 month ago
Thank you so much!! I have an exam tomorrow and this really helps me!!!
KimEunMi93 1 month ago
cheers man that was a great help thanx
tkl26 2 months ago
Thanks you!
ChaithanyaSN 2 months ago
This has been flagged as spam show
helped me so much!
HSeLiTe 2 months ago
Very clear. Thank you.
MrMustard12345 3 months ago
THANK YOU!!!!!!!!
djchris30 3 months ago
Thanks for the nice lesson
atrish1987 3 months ago
This is really helpful. Thx!
momoaloft 3 months ago
well done man...
9nedyah 5 months ago
thanks, this will really help for my test next week.
Jaksnacks 5 months ago
Thanks. Just had a brain fart and couldn't remember what to do.
NOLARealEstateTalk 5 months ago
This is really helpful! I hope I pass my computer lab preliminaries tomorrow! :)
calvz20 6 months ago
Is it possible to compute cells from several sheets in the same workbook? HELP!!! PLEASE!!!
israelrios78 6 months ago
Nasty time baby, nasty time. This nested if tutorial really helped. Thank you.
malcorub 8 months ago
thank you so much
prasadcool123 8 months ago
v well explained!
fashionistajolly2010 8 months ago
thank you helped me on my ICT test
MrAce2598 9 months ago
think you helped me on my ICT test
MrAce2598 9 months ago
have you got one on VLOOKUP's???
MalianaTMa 9 months ago
how could someone dislike this video ! evil people! but anyway the dislike bar is so tiny that it looks exactly like Justin bieber's tiny dick :)
Alanitoo 9 months ago 5
@Alanitoo i think your right
MrAce2598 9 months ago
stress free now!
JakeStevens18 10 months ago
I'd love for you to be my professor, she needs to be replaced anyways. You're a lifesaver!!!
StPatr1cksDay 11 months ago
"I would never do this...but this is nasty time"
kellowjo 11 months ago 9
great
the147break 11 months ago
Thank you so much!
Girl122334yeehaw 11 months ago
Could you show how to do the nested if function with 3 ifs or more, I add the coma after the parenthesis and doesn't work
Ddstairclimber 1 year ago
Enjoyed your video. Am having problems using the if function with the vlookup at the same time. Objecitve is to have clean worksheet if no data is input, instead of showing the "n/a" in the cell that contains a formula that awaits for data to be entered.
basically, my formula reads ( =if(e4>" ",vlookup(e4,hardware!$C$3:$M$104,2,0)," "). This formula works returns a blank cell but when I input data on e4, e5 remains blank!
What am I doing wrong. Do you have any videos that deals with this?
chowman007 1 year ago
thank u man ur a life saver
now time to do my uni work
reams 1 year ago
This is another great tutorial. Can you create one that discusses the VB with Excel... creating buttons?? Thanks so much!!!
MsNJohnson 1 year ago
IF my aunty had balls she would be my uncle....only messing great video!
montymagic1987 1 year ago
good shit man
20evan10 1 year ago
Thank you so much
helped me with an assignment :)
Jonasgal17 1 year ago
thanx dude
gviviff1 1 year ago
Thanks Heaps
ducky2393 1 year ago
Saved me a ton of time - thanks.
drumsfun 1 year ago
this was perfect. thank you so much!
preet23391 1 year ago
tres bon, cheeers helped with my GCSE 2moro!
Jamiecool80 1 year ago
thank you,very good tutorial
retox87 2 years ago