Mr Long you had stated make sure the info we looking for is in the left or outer left of the table if it is not? do we do something or will the examiner always make sure its on the left?
Hopefully it's always in the left. But lets say there is a table that covers columns A, B, C, D, and E. And now you are looking up data in column C to get information from column E. In that case, make the table from C to E rather so the lookup data is in the left column and now you are looking for data in column 2.
@MrLongITandCAT After putting in my range, I must go to the other table to get my criteria right. But when I click my other table like you did the system thinks I clicked "ENTER" & it gives me an error
Watching this video for the NSC tmr.
Me too let’s hope it goes well
@@mzwakhewelcome7472 We can do it 💪🔥
Did it the Mr Long way and got 92% ✊🏾
That's awesome! Well done!
Sbwl 😫
Sbwl mfanaaa
@@Mandy_11144 Yoh sana 😪✋
Few hours before NSC this REALLY helped wow
Twin😂
Hope it went well!
bro taught me more in 10min than my teacher did in 2 years
bro! like why are cat teachers like that
REAL
Honestly a life saver, thank you so so much for all your efforts that you put into these videos.
oh my gosh this was a real help its never been this easy you just saved my life about to write my NSC examinations
This is perfect for beginners honestly
sorry miss Jackson ouuu i am fo reallll😂😂
Never meant to make your daughter cry
I apologize a trillion times
top 10 youtube channels of all time!
Thank you soooo much,you are a lifesaver Mr Long!!!!
Glad the videos are helping!
im sorry ms jackson killed me🤣🤣🤣
Mr Long please do update the grade 12 excel playlist by adding pivot tables
as well as creating macros
13:24 caught that Outkast reference😂😂
10:33 i am for real
Mr Long you had stated make sure the info we looking for is in the left or outer left of the table if it is not? do we do something or will the examiner always make sure its on the left?
Hopefully it's always in the left. But lets say there is a table that covers columns A, B, C, D, and E. And now you are looking up data in column C to get information from column E. In that case, make the table from C to E rather so the lookup data is in the left column and now you are looking for data in column 2.
Love you man❤
hi mr long where can i download the sample data you use in your videos
Mine doesint allow me to refere to the other table
Hi. What do you mean by doesnt allow?
@MrLongITandCAT After putting in my range, I must go to the other table to get my criteria right. But when I click my other table like you did the system thinks I clicked "ENTER" & it gives me an error
OR MUST I USE BUILDING BLOCKS INSTEAD ?
@@Ace_03717 Maybe yes. Can you paste the formula here so I can see it?
🐐
Voorbrug high are you here😂
LOCK!
im sorry ms Jackson ooooh🎶 I am for real