All language subtitles for 3. Comparing Lists

Let us look at some other scenarios there.

Look up the different functions are very useful.

For example we can use look at functions to compare lists.

Here I have two lists.

The first list in column B has invoice numbers for the month of November.

In Column C I have invoice numbers for the month of December.

Now it is possible that the finance team while raising their voices made a mistake and there may be

duplicate invoice numbers between November and December.

Let us use relook and function to find duplicates between November and December invoices to do that

will take first December noise and compare it with all the November invoices to see if this value is

there in the November invoices list.

Then we'll select the second invoice in December and compared with all the never mind waste numbers.

We'll continue this process till we have compared all December invoices with November invoices.

Let us select Selby too.

And here will create a formula that compares the first invoice in December with the list of invoices

in November.

Once we do that we can simply copy and paste this formula.

The rest of the sales to compare the invoices from December.

Let us use the V look of formula here let us instead we look up the value that we are trying to find.

Is the invoice number in December.

So let's select the fossil in December and why says his then wife number will be looking for in the

table array which is the November invoices.

What do you want to return is if we look up finds this invoice number in the list of no invoices at

the center column and this number is 1.

If the duplicate value is following will get the duplicate invoice number here we are looking for exact

match because we are looking for duplicates.

So let's set it to 0.

Now you see that we look up it on and then and there is an error value.

So what happened was we look up picked up this invoice number in December and then look through the

number invoices.

But they did not find a match because it did not find a match.

It has it done an error of value in it.

So looking at the end we know that that December and wise is not duplicate but and it doesn't look nice.

It doesn't look good in this spreadsheet.

You don't want to see a bunch of.

And is no list.

So how can we make it look better let us use if and.

Is it a function that we learned earlier to make this a formatted output.

What we're going to do is if we look up finds a duplicate invoice it should say yes otherwise it should

just return blank.

So for all the duplicate invoices we'll have a yes for all the non duplicate invoices.

This column will be blank.

To do that let's first add that is error.

Function that either function will return true or false depending on the result of that we look up.

Function so we executed it.

You seem to be saying true because the relook at function is right now returning an error value in a

now let us use an IF function.

So that is the error test of the lookup is the logical test that we are doing.

And if that value is true meaning that no matter one's phone therefore we look at Britain and it and

therefore is error is saying is true then we return space or blank.

If we look at function return value the invoice number.

Then there is error function will not do that as an error.

So it will return a false and then they function will equate to false.

And if it cause the false then it means it's a duplicate in ways.

So let's say yes.

So you want it to return.

Yes.

Now you can see that cell B2 is blank because no duplicate was phone.

No let us make the reference to Columbia.

Absolute so we can copy this function down for other in ways in the most in December.

There is no copied and pasted in most of the cells and now you can see that for this enormous number

it has it under.

Yes.

Meaning is a duplicate invoice and for this one it does it under yes.

Meaning it's a duplicate invoice.

So this is how you can use.

We look at function to compare to list of data in Excel.