How to use Dynamic Arrays in Excel and other Advanced Formulas 

Its like heaven of excel teaching

A simply and straightforward marvelous Excel trainning explained and carried on by You Mrs.Ashby, all my support to your great channel and team of work. Stay well and a great HUG from trujillo- Perú.

From Congo thank you so much

really enjoying the lesson. Thank you

You have demystified so many things for me. Thank you!!!

Thanks God for simon sez It free titorial

Much appreciation for your efforts 🌹🌷💐

Thank you!

Thank you Deb Ashby!

Great tutorial 👌

More useful

Awesome....

mil gracias

At timestamp 19:07 all of the cell references are relative. At timestamp 19:18, the reference to the lookup table in cell H11 has changed to A10:E17. The original formula in H4 should have been =VLOOKUP(B4&C4,$A$3:$E$11,4,0). The change makes the lookup table absolute, while the lookup cells stay relative.

Hey, I have a question. What is the meaning of serial code in doing calculations while looking for duplicates if lookup value and lookup array is in the table itself

Plz check the download file. I tried multiple times to download via my email, but failed. My email address is correct but it does not work.

I dont understand why when you used the asterix to find HYNH product it showed light bulb and not shower seal? that one also has HYNH in its serial name.

Хвала!

👍💯