Hello, everybody, welcome to this second dashboard. In this video, we will see how to create this particular table using this particular data that we have created. Now, I went on and created a small format over here where I can just put in the country code compared to the country code just in the tabular format, so that we can convert this line item data into a table. The purpose of this table will be based on the US currency, what will the currency conversion be if it is in us sorry, if the user is selecting us, so the US dollar will be converted into different currencies, like for India, what will be the currency for $1 in us and so on and so forth. So, based on the selection across the countries, the currency will also change accordingly. Let's see how to get this thing done.

To make things easier, I have named the data to the left which is imported from the internet and so I will need This table currency internet. To do so, simply select the data and from here, put in the name in the Name box and press enter. Once done, it is confirmed. Do you remember the name box does not accept spaces. Now to use it, zoom the screen a little bit. That should do it.

To use it in the formula, we will be going with equals to V lookup or use the country code. We're all keep the G constant using the dollar sign, comma the data. Now I can actually go and select data that will in turn add the name or directed or as in the earlier videos as I have mentioned, if we forget the name, we can simply go to formula and from the drop down we can select the name from the list over here. So I'll go with Currency internet. So that will automatically select the data for me. Now, I'm looking for the third column, because that's the US currency actual conversions.

So I'll do that and I will have the answer the exact answer. And that will give the currency for us now currently, it is only for us. So if I drag it down, say three cells and according to that, I get the answer. Let's say $1 in us is equivalent to 1.32 in Australia. That means the value increases now, say if I tried for India, it should be 63 or 64. Based on the Indian currency, just let me check it.

So let's expand it with a little there it is. And so that's for the first table. Now the question is, as for Australia, it should be one So what I have to do is I have to divide it, so I will be dividing the same formula. I'll be using the same formula once again, that is copying and pasting it again. But this time the reference will not be the base rather it will be the heading, because it has to be divided with a heading. So now here I'll be keeping the third row constant.

Now why am I selecting the heading because when I shift to the other based on the heading, the currency will be divided. And I will get the actual currency of that particular country, something like this. So let me just drag it over and I'll select the frame down a little bit, scroll down holding the Shift key, select the whole frame and I'll just zoom back a little. Now to see the answer. I'll simply press Ctrl Enter when I'm into the formula mode. To come to the formula mode, press f2.

Now as I've already selected Did I can simply press Ctrl Enter to fill this particular formula across the data just to give a clear picture of what the data looks like. Now in in the US and for us the dollar is one rupee equivalent to one rupee that $1 is equivalent to $1. But in India $1 is equivalent to 64 rupees, but if it is the case of India one rupee equals to one rupee. So, if the user is selecting US dollar then this particular table will be captured as the currency converter. But if the person is selecting India, the currency conversion will take this particular data that is a table what it represents. Now, just to make things even better and easier to understand, wherever it's one rupee, I wish to see it in a green color.

To do that, simply select the whole data home conditional formatting, highlight cell rules equals to just put in a number one and then will give a straight line indicator that wherever intersections by country are happening, it is actually that same currency but this is for our understanding the formula is working perfectly, I'll just set the color to green Okay, and that should do it. So once done, I'll just reduce the font back to its actual and save this particular profile. So in the next video, we will see how to use this particular table to calculate our actual currency which we need to convert from the US dollar to the format that the user will select in the dashboard. Till then, keep practicing. I'll see you in the next video. Thank you