You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Comparing values in two columns on two sheets

Comparing values in two columns on two sheets

Price: FREE

I am not sure how to do this, but I'm hoping some of you Excel braininess can help me out.
I have 2 Sheets in an Excel 2007 file.
Sheet 1 is our Price Book and has two columns - "Part #" and "Part Price"
Sheet 2 is our Sales Record and has two columns - "Part #" and "Actual Sold Price"
I would like to add a third column to Sheet 2 - "Price Difference". I would like this column to take a Part #, find it on Sheet 1, and display the corresponding "Part Price". Ideally, this formula would calculate the difference between the Part Price and the Actual Sold Price, either in a dollar amount or a percentage.

Visit publisher's web-site: Comparing values in two columns on two sheets

Category and Tags: ExcelTutorials :

Related Tutorials

Comparing sheets

Free: Yes
Tags: Excel ›

I have my personal sheet with columns Name, Address and Comment, about 2600 rows. I sent it to my workers and everybody from them changed about 20-30 lines (unique -> there are no rows which has ben changed two times). Now I have 23 sheets with different comments. How to make one file with this?

Conditional Formatting based on comparing 2 values

Free: Yes
Tags: Excel ›

I've been searching around and haven't been able to find an answer for this particular issue so Im hoping someone can help.here it is
I have 2 sheets with columns of data, on both sheets in the 1st column I have an ID and the other columns have dates in them.
What I want to do is highlight a date on the first sheet if it differs to the date on the 2nd sheet but the check also needs to ensure the ID matches.
Basically this:-
Sheet A:-
A B
abcd 03/10/12
waxy 03/10/12
Sheet B:-
A D
abcd 03/10/12
waxy 03/11/12
As you can see the dates of "waxy" do not match in the different sheets and the dates are also in different columns. I would like to be able to highlight the date in Sheet A if this is the case.

comparing and isolating duplicates in two columns

Free: Yes
Tags: Excel ›

If I have values in column A, and values in column B, is there a quick and easy formula that will isolate the duplicates--the values that are identical--in the two columns? It's basically comparing 2 lists, names for example, and trying to cross reference them.

Comparing 2 or more columns to get a sum

Free: Yes
Tags: Excel ›

I'm trying to figure out how Excel can look at 2 or more columns, find values and associate them with a value or sum of values in another column.

Comparing two columns of same data

Free: Yes
Tags: Excel ›

I have two sheets and each sheet has the 1st column of email addresses.Lets say the 1st sheet has 20 emails and the second 25.Most of the emails are the same in both sheets.Now I need to find those emails that are in the 1st but not in the second and the other way around.

Related Applications & Scripts

Animated Sheet of Paper

Free: No
Tags: Flash › Excel Animations

Three sheets of paper that are laid on a desk. On each paper you can place your own text, image or anything you want!
- No Actionscript used. Completely done with shape and motion tweens for easy editing.
- The file is nested into a movie clip for easy drag n drop.
- Fully scalable to any size.
- You can easily adjust the duration of the paper by adding frames into its timeline.
- Only 31kb. - Comes with a help file.
- Usage: Useful for a educational banner, or maybe for a little schools newsletter!!

Two Columns Smooth ScrollBar AS2

Free: No
Tags: Flash › Excel Scrollbars

A smooth ScrollBar with an special feature: it scrolls two columns paragraphs at the same time, with a little delay, giving an special visual effect.
The preview shows an example with two text paragraphs. You can change the content, filling one column with a photo and the other one with text, mixing graphic and textual content. Try it!
The scrollBar has a corporate style useful for any website, also you can change (even dinamically) the color. AS2 Tweener is used for tweening.

Conversion of xml node values to a .NET type

Free: Yes
Tags: ASP.NET › Excel XML

This class is written for conversion of xml node values to a .NET type but can also be used to with plain strings. Every time I needed a node value I had to check if the node existed, is it an element or an attribute before I could even start converting the value. This class handles all this and using gen

Grid Manager

Free: No

The Grid Manager Magento extension allows store owners and administrators to manage columns in a table in store administration section and choose which columns to display, their size, position and title.

Key Generator

Free: No
Tags: ASP.NET › Excel Random Text

The KeyGenerator is a .NET component for .NET applications that allows to developers generate random values using the combination of numbers, letters, characters and custom values.
Principal features:
- Get random values using Numbers, Letters, Numbers & Letters, Numbers-Letters-Characters or custom values defined by you
- Include source code so you can add custom elements
- It is compatible with C# and VB projects (include demo apps for both)
- It is compatible with different types of .NET projects (web, desktop, console)

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing