Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • “If” formula for the letter the value begins with?

    I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...
    Posted to Functions and Formulas (Forum) by l.t.doppler on Wed, Oct 20 2010
  • Vlookup using 2 variables

    I am currently putting together a database of timesheets which contain Name, date, hours (plus others, but these are main ones). I need to lookup into a standing data table two criteria, the name and the date. The standing data consists of name, date of rate change and new rate. Therefore I need to find...
    Posted to Functions and Formulas (Forum) by kiteman22 on Sun, Mar 14 2010
Page 1 of 1 (2 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.