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!
Thanks God for simon sez It free titorial
That's very nice of you, thanks!
You have demystified so many things for me. Thank you!!!
Oh wow! That's nice of you to say that :-)
Much appreciation for your efforts 🌹🌷💐
It's my pleasure - thanks for your feedback.
Great tutorial 👌
Thank you Deb Ashby!
You are so welcome :-)
From Congo thank you so much
Hello to you and everyone from the Congo :-)
Thank you!
You're welcome! Thanks for watching our training ;-)
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 ➡️ th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Хвала!
Many thanks for the support :-)
Awesome....
Thanks 🤗
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!
mil gracias
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.
👍💯