Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE

[chinchonchinchon]

I've got it!

Random Numbers. In the beginning I thought this spreadsheet was bewitched! l0l

[ExcelIsFun]

Yes you got it:

Bewitched by randon numbers!

[Gilllionaire]

Thank you for this trick !

[sforsushi]

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,

[ExcelIsFun]

If it is a video at YouTube, then try to refresh.

[sforsushi]

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.

[ExcelIsFun]

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

[kjaan]

Never knew that you can use these function in such a way. Great job. What is the difference between lookup and Vlookup?

[ExcelIsFun]

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]

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)