Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Vlookup to pull a data from adjacent column 5

      • Billyrj
    3. Replies
      5
      Views
      995
      5

    4. MandyRead

    2. Vlookup to show average of a range 5

      • prkhan56
    3. Replies
      5
      Views
      173
      5

    4. Carim

    2. Vlookup to subtract values across worksheets 9

      • RobertJ
    3. Replies
      9
      Views
      5.1k
      9

    4. AliGW

    2. Vlookup using tabs with specific cell reference 2

      • wosborne
    3. Replies
      2
      Views
      1k
      2

    4. wosborne

    2. Vlookup using wildcard for fetching the data 3

      • hdevadiga
    3. Replies
      3
      Views
      1.1k
      3

    4. rory

    2. Vlookup value after comma+space & return each value seperated by comma+space 12

      • sandeepsandeep
    3. Replies
      12
      Views
      1.6k
      12

    4. sandeepsandeep

    2. Vlookup with dynamic capabilities 9

      • RobertJ
    3. Replies
      9
      Views
      1.3k
      9

    4. Carim

    2. Water Billing Rates Formula 2

      • EvanBerrett
    3. Replies
      2
      Views
      1.9k
      2

    4. EvanBerrett

    2. Way to calculate number of days within months from dates in table 4

      • Matt168
    3. Replies
      4
      Views
      519
      4

    4. Matt168

    2. WEEKDAYNAME function not working... error #NAME? (Excel 2013) 1

      • Dougmeister
    3. Replies
      1
      Views
      875
      1

    4. NBVC

    2. WEEKNUM system 1 and 2 2

      • arabella
    3. Replies
      2
      Views
      1.6k
      2

    4. arabella

    2. What is the average overall letter grade? 4

      • DrRandyman
    3. Replies
      4
      Views
      1.8k
      4

    4. Logit

    2. What was the average of their last three sales 4

      • 1003064
    3. Replies
      4
      Views
      576
      4

    4. JonathanVH

    2. When G matches B, count the number of values in C (that do not match H) 5

      • BJL
      • BJL
    3. Replies
      5
      Views
      1k
      5

    4. BJL

    2. Wilcard for vlookup

      • Pedro003
    3. Replies
      0
      Views
      185

    2. Wins in the Last 5 4

      • showtimesaints
    3. Replies
      4
      Views
      814
      4

    4. royUK

    2. Workdays in the Month formula? [SOLVED] 1

      • Johnnyv015
    3. Replies
      1
      Views
      414
      1

    4. Johnnyv015

    2. World Cup Wallchart 1

      • Garyhunt6809
    3. Replies
      1
      Views
      677
      1

    4. Garyhunt6809

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.3k
      21

    4. LearningXL

    2. Would like to use HLOOKUP() instead of using many Range Names 5

      • NGM
      • NGM
    3. Replies
      5
      Views
      887
      5

    4. AliGW

Label

Display Options