Thank you - can you tell me, how do I use multiple criteria to lookup info. For example the attached a company can have a variety of products delivered all to the same site and all under the same delivery number but they'll have different total values (per product). How do I go across the spread sheet to return the total value in sheet2 Product 2 #? Thanks
|