How to use the VLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program and we will be using VLOOKUP to find out which staff is vaccinated and which Vaccines they took. For example, Pfizer BioNtech, Moderna, Janssen or Sinovac. We will also show you how to convert your VLOOKUP function into an API at the end of the video.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
Excel Template: https://www.alchemyj.io/aj-excel-template
Learn More: How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ
How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ
Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/
How to use the VLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program and we will be using VLOOKUP to find out which staff is vaccinated and which Vaccines they took. For this example, we will be using Pfizer BioNtech, Moderna, Janssen and Sinovac. Without further ado, let us get started.
How to use VLOOKUP Function
Select Cell C23. Type in the equal VLOOKUP, open parentheses. Select Cell C22 and type in a comma. Select Cell B6 and drag your cursor to C20 and type in a comma. Next, we will type in 2. The 2 represent the 2nd column, which in this case represent Status. Lastly, we will type in FALSE. FALSE help us to find the exact match wording, which we will be typing in C22. Close paratheses and hit return and we gotten NA. It is because we have not put in the wording for our lookup. Select C22 and type in Elon and hit the return key. You will get Vaccinated in Cell C23. Let us type in Emma. This time we have gotten unvaccinated.
VLOOKUP can be used in separate excel as well. Let’s say we have an excel sheet of staff who is willing to travel during the epidemic period. How can we bring this table on sheet 2 to our staff COVID-19 Vaccination Program table on sheet 1? Let me show you how. Select Cell E6 and type in the equal VLOOKUP, open parentheses. Next, Select Cell B6 and type in a comma. We will now go into Sheet 2. Select Cell B6 and drag your cursor to Cell C20. Next, move your cursor to the formula bar and type in a comma. We are interested in finding out the staff who is willing to travel. Thus, we will type in 2 and type in a comma. Lastly, type in FALSE to find the exact match. Close parentheses and hit return. You will see the list of Yes and No for staff who is willing to travel or not.
There you have it, the VLOOKUP function for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorial. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.
Convert VLOOKUP function into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this VLOOKUP Function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select the AlchemyJ ribbon, select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will now launch this openAPI which AlchemyJ generates, and try using the VLOOKUP Function on it. I will expand this tab, and select try it out. I will input Elon and see if he is Vaccinated. Nice, he is Vaccinated. Alright, let’s try another example of Emma. What will we have? She is Unvaccinated at the moment.
AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.