Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Spreadsheet,Not sure what to use? Vlookup works for first
I have a excel problem with a formula for a spreadsheet, basically I am
trying to combine two accounting spreadsheets. Lets call them spreadsheet A & B. All my values are in spreadsheet A and this contains four columns. see below Code Description Division Amount 1 COGS sales 10 1 COGS manufacturing 15 2 expenses sales 12 2 expenses manufacturing 17 Now I need the amount in spreadsheet B which is organized like this SALES Manufacturing COGS EXPENSES Now for sales i have put in=vlookup(A2,spreadsheet B!A2:D5,4,False) and this works but it doesnt work for manufacturing as it brings up the first thing it find (for example it brings $10 and $12) I gues my question is How do I create a formula that takes columns one and three into account from another spreadsheet in order to get column four in a different spreadsheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
MS Works Spreadsheet 2000 v5.0 VLOOKUP | Excel Worksheet Functions | |||
ms works spreadsheet | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) |