| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look Up
Is there an easy way to look up entries in one tab called "PART" and if
there is an entry in another tab say "MASTER" then subtract column "C" of PART from column "C" of MASTER Regards Ray |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Look Up
just use the VLOOKUP function.
Patrick Molloy Microsoft Excel MVP -----Original Message----- Is there an easy way to look up entries in one tab called "PART" and if there is an entry in another tab say "MASTER" then subtract column "C" of PART from column "C" of MASTER Regards Ray . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Look Up
And put the answer where?
if you are trying to run an inventory program and trying to keep a running total of current inventory, then I doubt you will be successful doing this with formulas unless you keep all transactions and accumulate the changes. -- Regards, Tom Ogilvy wrote in message ... Is there an easy way to look up entries in one tab called "PART" and if there is an entry in another tab say "MASTER" then subtract column "C" of PART from column "C" of MASTER Regards Ray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
