Okay so it's now time to learn another very important feature of Excel which is minted by fitness users
every single day.
Uh first of all let me let me introduce you to the problem.
The problem here is that we have all of our data now our sheet which you can transfer.
I give brand name asking you cost price and other some other information.
But we have some information in Sheet 2 and this sheet to us rock weighed against the propriety.
What we actually want is that we want the corporate dimension in this particular sheet rather than in
Sheet 1.
Now the problem is I can not simply copy paste this data because this data sorted on some other parameter
and it I.D. work ideas are quite mixed.
You can see that broad ideas twenty eight off the deck 178 170.
So I can not simply copy and paste this data here I want the rate of fraud I do want to be in this as
well but I did to to be in this role.
So for that we want what you can do is that you can do it manually one by one paper.
I do 1 4 2 4.
Let's go to Sheet 1 and find the bird.
I.
Well it would take quite a lot of time.
So let's use our table of teacher control f find find work find but I do one.
So let me first to this column.
Fight for it.
I one.
Yes yes yes yes yes.
It is giving all down to the label but one so that is not the smartest way of doing it.
And even if we find one we find two will find three.
It will be taking me a lot of time to find and write every single read everything that works with here
in this column.
So a smarter way of doing it as we look up verticals look up.
So we will be applying a formula in the sheet that would bring in all the product rates against that
or I.D. from sheet to do Sheet 1 select start being it possible let's suppose any fourth time here.
And right.
Look up so no Excel all what you're going to do if you're trying to applying relook of formula to just
press that gap button and it looks like this formula for you know really cause is asking you to look
for work what you are looking for.
I'm looking for right I.D. voter fraud I.D. And after that press a comma not a cat selected for broad
I.
Next you're looking for propriety.
The next question is really who are looking at this data that you are looking to attack against it.
So will go to sheet do analysis like all of this cheat you all of that data here from top to bottom
so that Excel finds that anywhere in this in this table it would give me the answer.
So once all the data has been selected I will press Chroma again and I will press to so that Excel knows
that what I want what I want to bring from sheet to good sheet one is in the second column of my dad
and that has been selected and I will press home again and I will press for what is to ensure that Excel
brings in the exact match and I will close the bracket once that bracket has been closed click enter
and you will see that Excel has brought the broad idea and the wheat from sheet to to sheet one against
the profiling.
So what I will do is that I will copy paste this formula to all the cells below this particular cell.
So the we go to that let's first log our cells to bring in the absolute values.
I will go to this particular A2 and press F4.
Now I will go to this particular setting up of the press effort again.
Okay.
The cells have been blocked.
I will simply copy and paste this data all the way in the column and you will see that all of those
values form she too has been brought to sheet one against those particular cells.
So let's check some values.
So for example say I want to check this last one fund I picked up the rate is twelve point five.
Let's go to sheet 1 and see if that is right.
So I was planning to go and let's say control 5 1 5 6 0.
Enter and for this one purpose we report the greatest twelve point five.
Let's go and check in sheet 1 the way it is towards my pipe.
Let's do another try.
1 5 5 9 sheet 1.
Control 1 5 5 9.
And select find the rate should be 21 cages.
Let's go back and check if it is 21 get it.
So if we look up has brought all the data from sheet two to shoot one with one particular smarter formula.
Now it doesn't matter.
It was only 10 because it was ten thousand because all of that shit data from the sheet 2 can be copied
to Sheet 1 in a smarter way.
So I really hope you like this will go function.
I guess the one virtually clear function that assumes the business uses every single day.
So let me just give it to you for the heading up the way it
and next point up this lecture.