Скачать или смотреть Vlookup formula with match function. two way lookup with vlookup

In our previous video we #learnedit about #Match #function
Today we will do #vlookup with #twoways in #excel lets use V look up and Match function together to do the two way look up.
When we close the #parentheses it means to close the #match #formula and resume v look up. comma, In range look up, select false for exact match.
Close another #parentheses to close the v look up function and hit #enter
Now drag your data #horizontally and #vertically to apply the formula into all fields.

Thanks for watching!

This short tutorial is best for Virtual assistants to improve their skills and earn money only. Our aim is to prepare VAs for the new techniques so they will be able to work effectively and productively online. After learning these skills the VAs will be able to work as Virtual assistant on Fiver, Amazon, Upwork, Guru, freelancer etc.
Subscribe to our channel for more productivity. We will be posting regular tutorials for Virtual Assistants.
Because Learning is a journey and making the first steps is important to start this journey.


Follow us on Tiktok:
  / holp365  
Our entertainment channel:    / @hameed1982  
Our Facebook page:
  / silenthunterfx  

Our #hashtag
#productivity
#virtualassistantcourse
#virtualassistant
#virtualassistanttraining
#microsoftexcel
#officelife
#excelfreelearning
#freelancing
#productive
#tutorialforbeginner
#tutorialforbeginners
#beattheboss
#worklife