Look Up

[Guest]

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

 

[Patrick Molloy]

just use the VLOOKUP function.

Patrick Molloy
Microsoft Excel MVP

 

[Tom Ogilvy]

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.