Updated: Jul 6
I have created a staff COVID-19 vaccination program, and we will be using HLOOKUP to find out which staff is vaccinated. We will be using Pfizer BioNtech, Moderna, Janssen and Sinovac in our Excel examples.
We will also show you how to convert your HLOOKUP 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
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
How to use the HLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program, and we will be using HLOOKUP to find out which staff is vaccinated. For this example, we will be using Pfizer BioNtech, Moderna, Janssen and Sinovac. If you wish to learn the VLOOKUP function. We had made a video on it. Do check out the link above. Okay, without further ado, let us get started.
How to use HLOOKUP Function
Let us create a Staff Name drop-down function that would help us verify who is Vaccinated or not at our HLOOKUP Function in Excel. Select Cell C10. Next, move your cursor and select the data tab. Select Data Validation and click on data validation. Select the drop-down menu in the “Any Value” and select the “list” option. Next, select the source text box. Move your cursor to Cell C5. Select and drag your cursor from Cell C5 to Cell I5. Hit return. Now, in Cell C10 drop-down menu. Let us select Elon.
Now we will be creating the HLOOKUP Function to check if Elon is Vaccinated. Select Cell C11. Type in the equal HLOOKUP, open parentheses. Select on our Lookup value. Which will be Cell C10 and type in a comma. Now, we will need to select our table array. Move your cursor to Cell C5. Select on it and drag it to Cell I8. Type in a Comma. Next, we will need to find the vaccination status. In our excel template, the status is located in row 3. Type in 3 and a comma. Finally, we will input false. False tells the excel that we are looking for an exact match. Close parentheses and hit return. Alright, Elon is Vaccinated. Let us check if Jeff is vaccinated? Nope, he isn’t.
There you have it, the HLOOKUP 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 HLOOKUP function into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this HLOOKUP 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 HLOOKUP 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.
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.