i did the refresh and click the video again, then a red band appeared said" this account is suspened." i thought it was my account problem, then i sign out and click the video again, but the red band remained.
VLOOKUP is vertical lookup and do both aproximate and exact match depending on the 4th argument. LOOKUP can do horizontal or vertical lookup depending on the shape of the table and can only do aproximate lookup. I have many video that show ALL the details of both of these functions.
Please teach yourself how to use the excelisfun channel by searching for and then watching this video title:
I've got it!
Random Numbers. In the beginning I thought this spreadsheet was bewitched! l0l
chinchonchinchon 1 year ago
Yes you got it:
Bewitched by randon numbers!
ExcelIsFun 1 year ago
Thank you for this trick !
Gilllionaire 2 years ago
Hi, sir. I'm your big fan. Just now when i click your Accounting 124 Excel video, it failed to open. could you tell me how to fix that? Thanks,
sforsushi 2 years ago
If it is a video at YouTube, then try to refresh.
ExcelIsFun 2 years ago
i did the refresh and click the video again, then a red band appeared said" this account is suspened." i thought it was my account problem, then i sign out and click the video again, but the red band remained.
sforsushi 2 years ago
OOO, you are talking about a playlist. The Accounting 124 Playlist is deleted.
Serach for and watch this video title to learn how to find the videos that you may want at the excelisfun channel:
Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun
ExcelIsFun 2 years ago
Never knew that you can use these function in such a way. Great job. What is the difference between lookup and Vlookup?
kjaan 2 years ago
VLOOKUP is vertical lookup and do both aproximate and exact match depending on the 4th argument. LOOKUP can do horizontal or vertical lookup depending on the shape of the table and can only do aproximate lookup. I have many video that show ALL the details of both of these functions.
Please teach yourself how to use the excelisfun channel by searching for and then watching this video title:
Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun
ExcelIsFun 2 years ago
After you know how to find the Playlists, I have two playlists that have all the details of VLOOKUP nad LOOKUP. The names of the Playlists are:
1) Lookup functions Series
2) Excel Series: Lookup Functions & Formulas (this one has ALL the details)
ExcelIsFun 2 years ago