| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that meets table requirement then multiplies by table fac
I'm looking for a function that will reference a cell then lookup that cell
in a table and use the multiplier in the table. I'm not explaining very well so Im hoping that my example will help you understand: Column A b c Sector P&L w/o Admin P&L w/ Admin PC 517.9 PC 0.0 PC 0.0 TD 1,993.6 TD (2,508.0) TS 431.3 TS 355.7 Table reference: FD 1.20 PC 1.03 PR 1.52 SIJ 1.00 TD 1.32 TS 1.63 In column C I would like to put a formula that; if column A mactches column A in table reference then it will mutiple column B * column B in refernce table. I hope the example helpd you to understand. I'm using excel 2003 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that meets table requirement then multiplies by table fac
Hi,
See your previous post "goonie" wrote: I'm looking for a function that will reference a cell then lookup that cell in a table and use the multiplier in the table. I'm not explaining very well so Im hoping that my example will help you understand: Column A b c Sector P&L w/o Admin P&L w/ Admin PC 517.9 PC 0.0 PC 0.0 TD 1,993.6 TD (2,508.0) TS 431.3 TS 355.7 Table reference: FD 1.20 PC 1.03 PR 1.52 SIJ 1.00 TD 1.32 TS 1.63 In column C I would like to put a formula that; if column A mactches column A in table reference then it will mutiple column B * column B in refernce table. I hope the example helpd you to understand. I'm using excel 2003 Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that meets table requirement then multiplies by table
I saw the previous answer.
Sorry about the double post. I didn't see that the other post was posted until I had typed another. "Eduardo" wrote: Hi, See your previous post "goonie" wrote: I'm looking for a function that will reference a cell then lookup that cell in a table and use the multiplier in the table. I'm not explaining very well so Im hoping that my example will help you understand: Column A b c Sector P&L w/o Admin P&L w/ Admin PC 517.9 PC 0.0 PC 0.0 TD 1,993.6 TD (2,508.0) TS 431.3 TS 355.7 Table reference: FD 1.20 PC 1.03 PR 1.52 SIJ 1.00 TD 1.32 TS 1.63 In column C I would like to put a formula that; if column A mactches column A in table reference then it will mutiple column B * column B in refernce table. I hope the example helpd you to understand. I'm using excel 2003 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a formula that multiplies columns? | New Users to Excel | |||
| Creating a formula which multiplies by two seperate %'s | Excel Worksheet Functions | |||
| extract data from table that meets set criteria | Excel Discussion (Misc queries) | |||
| Function to look up largest value whose record meets criteria? | Excel Worksheet Functions | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Linear Mode
