Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using VLOOKUP to condense data on separate spreadsheet
Hello all-
I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name total 1 12345 misc $100.00 2 12345 misc $50.00 1 12367 oil $100.00 Sheet2: branch acct# name total 1 12345 misc ??? If I was doing an if/then setup on this, it would be IF branch=1 AND acct#=12345 on Sheet1 THEN put the total from sheet1 into the total cell for sheet2. What would be the best way to tackle this? I was thinking starting =IF(VLOOKUP...What formula would I be placing in sheet2 total cell? Thanks In Advance - Jason |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using VLOOKUP to condense data on separate spreadsheet
=SUMPRODUCT(--(Sheet1!A2:A5000=Sheet2!A2),--(Sheet1!B2:B5000=Sheet2!B2)--(Sheet1!C2:C5000=Sheet2!C2),Sheet1!D2:D5000)
"ORLFREIGHTBOY" wrote: Hello all- I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name total 1 12345 misc $100.00 2 12345 misc $50.00 1 12367 oil $100.00 Sheet2: branch acct# name total 1 12345 misc ??? If I was doing an if/then setup on this, it would be IF branch=1 AND acct#=12345 on Sheet1 THEN put the total from sheet1 into the total cell for sheet2. What would be the best way to tackle this? I was thinking starting =IF(VLOOKUP...What formula would I be placing in sheet2 total cell? Thanks In Advance - Jason |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using VLOOKUP to condense data on separate spreadsheet
I'm actually not looking to add the columns together, I just want to carry
the number in the total column from sheet1 to sheet2...what do you think? Thanks, Jason "ORLFREIGHTBOY" wrote: Hello all- I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name total 1 12345 misc $100.00 2 12345 misc $50.00 1 12367 oil $100.00 Sheet2: branch acct# name total 1 12345 misc ??? If I was doing an if/then setup on this, it would be IF branch=1 AND acct#=12345 on Sheet1 THEN put the total from sheet1 into the total cell for sheet2. What would be the best way to tackle this? I was thinking starting =IF(VLOOKUP...What formula would I be placing in sheet2 total cell? Thanks In Advance - Jason |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using VLOOKUP to condense data on separate spreadsheet
I would temporarily create 2 sheets; sort one for branch 1 only and one for
branch 2 only. You will need to do this for both files. Then I would use the VLOOKUP function on each sheet, using the account number as the lookup value and return your totals-- for example: File 1 Sheet1: my look up sheet branch acct# name total 1 12345 misc $100.00 and File 2 Sheet 2: my return value sheet Sheet2: branch acct# name total 1 12345 misc ??? Amy "ORLFREIGHTBOY" wrote: I'm actually not looking to add the columns together, I just want to carry the number in the total column from sheet1 to sheet2...what do you think? Thanks, Jason "ORLFREIGHTBOY" wrote: Hello all- I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name total 1 12345 misc $100.00 2 12345 misc $50.00 1 12367 oil $100.00 Sheet2: branch acct# name total 1 12345 misc ??? If I was doing an if/then setup on this, it would be IF branch=1 AND acct#=12345 on Sheet1 THEN put the total from sheet1 into the total cell for sheet2. What would be the best way to tackle this? I was thinking starting =IF(VLOOKUP...What formula would I be placing in sheet2 total cell? Thanks In Advance - Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using vlookup between two separate sheets | Excel Worksheet Functions | |||
using VLOOKUP across two separate worksheets | Excel Discussion (Misc queries) | |||
vlookup formula not working with data on separate sheet | Excel Worksheet Functions | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
How do I link separate Excel files to one spreadsheet? | Excel Discussion (Misc queries) |