Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pull in 2 different rows and compare them
What I am trying to do is automatically compare totals in column F fro
two different excel sheets according to their account ID. What I nee is to be able to pull both row F into the 3rd sheet and have th account ID match side-by-side along with its corresponding total. Th reason is because sometimes Sheet 1 has an account that does not exis in Sheet 2. The look I am trying to accomplish is manually displaye below: Account ID 1 Account ID 2 100 100 101 101 102 103 103 104 104 Thanks in advance for any assistance. yale -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pull in 2 different rows and compare them
If account 2 will be the only one missing values,
copy Sheet1 to sheet3, and remove columns you don't need. next to account 1, use the vlookup function in B2 or whatever column for the account 2 info =if(isNA(Vlookup(A2,Sheet2!$A:$F,1,False)),"",Vloo kup(A2,Sheet2!$A:$F,1,Fals e)) then drag fill down the column. Assume the account ID in book2 is to get column F values change 1 to 6 in the 3rd argument to vlookup. -- Regards, Tom Ogilvy "yalex " wrote in message ... What I am trying to do is automatically compare totals in column F from two different excel sheets according to their account ID. What I need is to be able to pull both row F into the 3rd sheet and have the account ID match side-by-side along with its corresponding total. The reason is because sometimes Sheet 1 has an account that does not exist in Sheet 2. The look I am trying to accomplish is manually displayed below: Account ID 1 Account ID 2 100 100 101 101 102 103 103 104 104 Thanks in advance for any assistance. yalex --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pull in 2 different rows and compare them
Thanks for the help. I'm trying to not have to copy, paste, or delet
anything from Sheet 1 or Sheet 2 due to the fact that I would like t be able to import other data into those two sheets and have i automatically pulled into Sheet 3 and put into their respectiv locations to be compared. If there is another way to do it withou having to move any of the data in sheet 1 and 2 then I would love t know how to do it. Much appreciated. yale -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pull in 2 different rows and compare them
You don't have to do anything to sheet1 or sheet 2. You copy sheet1 to
create sheet3, then do the work there. -- Regards, Tom Ogilvy "yalex " wrote in message ... Thanks for the help. I'm trying to not have to copy, paste, or delete anything from Sheet 1 or Sheet 2 due to the fact that I would like to be able to import other data into those two sheets and have it automatically pulled into Sheet 3 and put into their respective locations to be compared. If there is another way to do it without having to move any of the data in sheet 1 and 2 then I would love to know how to do it. Much appreciated. yalex --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare two columns and pull out differences | Excel Discussion (Misc queries) | |||
what formula do I use to pull rows containing a number? | Excel Discussion (Misc queries) | |||
Pull user-specified rows from data set | Excel Discussion (Misc queries) | |||
How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
how to format pull down rows | Excel Worksheet Functions |