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

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


.

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