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

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • 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 (Forum) by Nick Hodge on Tue, Nov 18 2008

  • Data lookup

    I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
    Posted to Functions and Formulas (Forum) by Fishin Technishun on Wed, Aug 13 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.