Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
thank you very much for the clear explaning . in the menuet 44 when you talk about the IF function i tried this line of index and match insted 4 times of if and its works very well: =INDEX($J$2:$K$6,MATCH(G2,$J$2:$J$6,0),2).
This was very good. Just a quick question, the function executed by Index/Match can be done easily by Vlookup as well, Am I correct? Can you help with a scenario wherein only Index/Match can be used and Vlookup is not helpful?
Thank you Ashby. You did a great job. And Thank you Simon as well for hosting this video.
No problem. Glad you enjoyed our webinars.
That was amazing. Thank you for sharing the knowledge with us
Thanks for watching Alex!
Ashby, you are great teacher! Love the way you teach us!
Thank you! 😃
You have no idea how much you've helped me! Im soo grateful that I came across your channel thank you! thank you!!!
It's always great to learn that we are helping someone :-) Thanks for sharing the positive comments!
I'm so impressed with your tutorial and the professionalism that you guys have that if a could, I would give 10000 like
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Hallo, Thanks for the free lessons:-)
Glad you like them!
THANKS ATON streamskills very valuable and fruitful webinar. DEB ASHBY ROCKS..
Glad you enjoyed the webinar!
thank you very much for the clear explaning . in the menuet 44 when you talk about the IF function i tried this line of index and match insted 4 times of if and its works very well: =INDEX($J$2:$K$6,MATCH(G2,$J$2:$J$6,0),2).
very useful! thanks.
Glad it was helpful!
This was very good. Just a quick question, the function executed by Index/Match can be done easily by Vlookup as well, Am I correct? Can you help with a scenario wherein only Index/Match can be used and Vlookup is not helpful?
Really useful ....and please no GOT spoilers ....
Of course! Glad you found it useful.
In text functions Part Number is GBR-165-LHR, how to replace GBR by 165 and 165 by GBR at one go
Find and replace method. Find GBR-165-LHR and replace it with 165-GBR-LHR.👍