How to Use Excel to Match Up Two Different Columns : Using Excel & Spreadsheets

Subscribe Now:

Watch More:

Using Excel to match up two different columns will require you to go back to the original table that you've been working with. Use Excel to match up two different columns with help from a Microsoft certified applications specialist in this free video clip.

Expert: Jesica Garrou
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is still the most widely used spreadsheet creation tool in existence for both the PC and Mac platforms. Get tips on Microsoft Excel with help from a Microsoft certified applications specialist in this free video series.

[johnmiller]

this was confusing as hell and i cant see the formula you entered

[soumensarkar]

Thank you. It solved the precise thing I was looking for.

[gabyfeinbloom]

Can you post the formula here. It was blurry on the video. Thanks.

[nagarajrrnc]

hello i want know how to same reference values used to get the multiple cell value to different cell please give me any suggestion r formula

[MikeDancy]

That was awesome. Very useful. Thanks

[imranijazbutt]

Is there a way we can make difference in cases while comparing two lists as well for example excel show the message "APPLE" and "apple" are not same?

[mahfuzpolashrms]

Many many thanks for this video, its solve my many problems, Tank you again.

[PIGEONPENGUIN]

Omg, bless you! Thank you, thank you thank you!

[asuero]

awesome, this will save me a lot of time, thank you

[mohammadnazarsaqi]

THanks alot for sharing such useful information, and how to llink two different columns in from one sheet to another sheet?

[ceecee]

Love the video but How can we get all the rows which have a particular value in either of columns?

[Mahesh-vkzj]

What if one column contains number and second column contains some text plus numbers.

[karenolivo]

Thanks! I have that SAME necklace! :)

[venkydharshan]

How to Display duplicate multiple data row wise

[aftabbaba]

Ma'am. I don't want to highlight.
Is it possible that same name come to front of same name ?

[RuneHansen]

Couldn't get this to work in office 365.. am I doing it wrong, I am typing your formular, just in different columns. I have pc names in column "A" that I want to match or see if they are there in my other column, N.

[LandMerchant]

yOUR SCREEN IS BLURRY COULD YOU PUT THE FORMULA IN THE DISCRIPTION

[roaringmaratha]

Can anyone write that formula in comment... As it is blure in video

[kuldeepmore]

Works only if you have same number of rows in both columns!

[MrStu]

Why would you need to write a formula? Conditional formatting does the same thing.