Search : in
By :

Match two columns in different sheets

Last answer on Apr 21, 2009 6:51:48 am BST mahee, on Apr 17, 2009 12:33:34 pm BST 
 Report this message to moderators

Hello,

I have three work sheets with columns namley process code, process name, quantity produced per day. I need to create another sheet comprises of process code, process name and quantity produced monthly so that to sum up all the quantity produced for a particular process that appears in all 3 sheets. I have tried pivot table but my data also has blank spaces, hence vlookup is then also not returning correct values. Please please somebody help me on this issue! I'll be very very thankful. :)

Configuration: Windows Vista
Firefox 3.0.8
Ms Office 2003

Best answers for « match two columns in different sheets » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 Show Excel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Compare names for match in 2 columns Show
How to match two columns Show
Excel - Extract identical cells of 2 columns ShowExcel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Excel - COUNT # ROWS where 2 conditions are true ShowExcel - COUNT # ROWS where 2 conditions are true Issue Solution Note Issue I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORITY ACTIVE 1 2 Y...
SCSI ShowIntroduction to the SCSI interface The SCSI standard (Small Computer System Interface) is an interface used to connect several different types of peripherals to a computer via a card, known as the SCSI adaptor or SCSI controller (generally...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...
Ask your question Reply

1

 mikloise, on Apr 21, 2009 6:51:48 am BST
  • +11

What if you try =Sheet1!Cell needed do that for the start of all three columns and then just drag the formulas down the column.

   
Reply to mikloise
Ask your question Reply
They need your help