Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Vlookup function copying from different workbook and different sheet names.

      • Awesomun
    3. Replies
      0
      Views
      148

    2. vlookup formula with isblank or iserror formula 1

      • krpatel
    3. Replies
      1
      Views
      658
      1

    4. NBVC

    2. Vlookup formula with date conditions 3

      • GarethR
    3. Replies
      3
      Views
      815
      3

    4. bosco_yip

    2. VLookup Formula that can change Negative number to Positive and leave Positive 1

      • Washerz
    3. Replies
      1
      Views
      3k
      1

    4. Carim

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

      • elsuji
    3. Replies
      7
      Views
      821
      7

    4. elsuji

    2. Vlookup formula does not work for some cell 4

      • Excel&VBA
    3. Replies
      4
      Views
      878
      4

    4. Excel&VBA

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

      • eae
      • eae
    3. Replies
      4
      Views
      672
      4

    4. eae

    2. VLOOKUP Error 2

      • DezB
    3. Replies
      2
      Views
      334
      2

    4. DezB

    2. VLOOKUP does not return the correct values 1

    3. Replies
      1
      Views
      918
      1

    4. crushdrinker06

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

      • Elusive
    3. Replies
      9
      Views
      2.1k
      9

    4. sktneer

    2. Vlookup based on Range Name 9

      • mitank
    3. Replies
      9
      Views
      359
      9

    4. mitank

    2. vlookup based on date 1

      • robin a
    3. Replies
      1
      Views
      187
      1

    4. NBVC

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

      • chrismoore989
    3. Replies
      5
      Views
      735
      5

    4. NBVC

    2. Vlookup and If formula 3

      • DaveSharpe79
    3. Replies
      3
      Views
      523
      3

    4. Ingo_Ingo

    2. Vlookup across multiple worksheets and list sheet names

      • onexc
    3. Replies
      0
      Views
      65

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

      • ANku86
    3. Replies
      5
      Views
      8.8k
      5

    4. KjBox

    2. VLookup 6

      • JulianR
    3. Replies
      6
      Views
      425
      6

    4. JulianR

    2. Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1

      • jpetraityte
    3. Replies
      1
      Views
      328
      1

    4. Estevaoba

    2. Vlook up 5

      • jpetraityte
    3. Replies
      5
      Views
      908
      5

    4. jpetraityte

    2. Vertical lookup when the range changes. 8

      • JoDor
    3. Replies
      8
      Views
      1.4k
      8

    4. JoDor

Label

Display Options