If there were only one entry, then I bet you could.

But if there is more than one entry, you can use =sumif()

=sumif(sheet2!a:a,"product1",sheet2!b:b)




tb wrote:

I am trying to find a formula to total a specific product from a list into
another worksheet for totals.

Can i use a LOOKUP formula to look for that specific product and give me
totals for the year in another worksheet?

Thanks;

--

Dave Peterson