Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VLOOKUP (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Excel 2007 and 2010 forum. See all tags in the site
  • vlookup within vlookup

    I have two tables that i want to add together depending on values to produce a thrid summary table. Table one has the amount of days per month worked in each stage of the project. July August September Feasibility 144 168 160 Concept 70 176 160 Detail 160 24 0 Table two has all the rates of the different...
    Posted to Excel 2007 and 2010 (Forum) by nbothandford on Tue, Sep 9 2014
  • What VLOOKUP & SUM formula would I use ?

    Hi I have two worksheets. One listing all days against a individual contract e.g. Contracts Days 1234 1 1234 4 1234 2 1234 9 1235 1 1235 6 1235 0 1235 11 1236 7 1236 2 1236 20 1237 1 1237 7 1237 5 1237 5 and the other where I want to look this days total up for that contract e.g. Contract Total days...
    Posted to Excel 2007 and 2010 (Forum) by George3578 on Fri, Sep 5 2014
  • Re: syntax for performing 2 VLOOKUP funcitions in 1 Cell

    Felix I hope I have understood. (My testing had your Product ID (lookup value) in A1 and the Sampling Point Table in A4:C50 on the same sheet. (Just change these to suit)) I came up with this, which tests first if the Product ID exists at all using the AND function and ISERROR, if that returns TRUE I...
    Posted to Excel 2007 and 2010 (Forum) by Nick Hodge on Tue, Nov 18 2008
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.