Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Vlookup formula for sum the values with filtering the data's month wise 7

      • elsuji
    3. Replies
      7
      Views
      364
      7

    4. elsuji

    2. Vlookup formula does not work for some cell 4

      • Excel&VBA
    3. Replies
      4
      Views
      473
      4

    4. Excel&VBA

    2. vlookup for 2 criteria from multiple columns that change daily 4

      • eae
      • eae
    3. Replies
      4
      Views
      377
      4

    4. eae

    2. VLOOKUP Error 2

      • DezB
    3. Replies
      2
      Views
      188
      2

    4. DezB

    2. VLOOKUP does not return the correct values 1

    3. Replies
      1
      Views
      730
      1

    4. crushdrinker06

    2. vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9

      • Elusive
    3. Replies
      9
      Views
      1.5k
      9

    4. sktneer

    2. vlookup based on date 1

      • robin a
    3. Replies
      1
      Views
      118
      1

    4. NBVC

    2. VLOOKUP and reference another cell for the LookupTable"NAME" 5

      • chrismoore989
    3. Replies
      5
      Views
      386
      5

    4. NBVC

    2. Vlookup and If formula 3

      • DaveSharpe79
    3. Replies
      3
      Views
      280
      3

    4. Ingo_Ingo

    2. vlookup #n/a error when values exist 5

      • ANku86
    3. Replies
      5
      Views
      4.6k
      5

    4. KjBox

    2. Vlook up 5

      • jpetraityte
    3. Replies
      5
      Views
      319
      5

    4. jpetraityte

    2. Vertical lookup when the range changes. 8

      • JoDor
    3. Replies
      8
      Views
      657
      8

    4. JoDor

    2. VBA to insert IF formula to convert dates to DD/MM/YYYY 8

      • Rovi
      • Rovi
    3. Replies
      8
      Views
      864
      8

    4. Rovi

    2. VBA Code Modification 11

      • Excel&VBA
    3. Replies
      11
      Views
      502
      11

    4. royUK

    2. Variable to excel formula

      • NewbieError
    3. Replies
      0
      Views
      120

    2. Variable columns possible in Sumproduct (vlookup) formula 5

      • bob22
    3. Replies
      5
      Views
      1.1k
      5

    4. Carim

    2. Variable Cell Reference based on Path 9

      • xlbrian
    3. Replies
      9
      Views
      668
      9

    4. Carim

    2. value within 3 of other cells on the row 3

      • cspgsl
    3. Replies
      3
      Views
      361
      3

    4. Carim

    2. Validation List values from 3 columns based on INDEX MATCH of value offset from cell 3

      • t.palinkas
    3. Replies
      3
      Views
      456
      3

    4. t.palinkas

    2. Validation List using a Table 3

      • mar050703
    3. Replies
      3
      Views
      216
      3

    4. royUK

Display Options