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ú.
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
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.
Its like heaven of excel teaching
really enjoying the lesson. Thank you
You're very welcome!
You have demystified so many things for me. Thank you!!!
Oh wow! That's nice of you to say that :-)
Thanks God for simon sez It free titorial
That's very nice of you, thanks!
From Congo thank you so much
Hello to you and everyone from the Congo :-)
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ú.
Thanks for the kind comments 🙂 Learn Microsoft Excel Tips and Tricks here ➡️ ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Much appreciation for your efforts 🌹🌷💐
It's my pleasure - thanks for your feedback.
Great tutorial 👌
Thank you Deb Ashby!
You are so welcome :-)
Thank you!
You're welcome! Thanks for watching our training ;-)
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.
More useful
Glad you think so!
Awesome....
Thanks 🤗
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
mil gracias
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.
Хвала!
Many thanks for the support :-)
👍💯