Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • Awesomun
    2. Replies
      0
      Views
      146
    1. vlookup formula with isblank or iserror formula 1

      • krpatel
    2. Replies
      1
      Views
      655
      1
    3. NBVC

    1. Vlookup formula with date conditions 3

      • GarethR
    2. Replies
      3
      Views
      807
      3
    3. bosco_yip

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

      • Washerz
    2. Replies
      1
      Views
      2.9k
      1
    3. Carim

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

      • elsuji
    2. Replies
      7
      Views
      807
      7
    3. elsuji

    1. Vlookup formula does not work for some cell 4

      • Excel&VBA
    2. Replies
      4
      Views
      872
      4
    3. Excel&VBA

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

      • eae
      • eae
    2. Replies
      4
      Views
      668
      4
    3. eae

    1. VLOOKUP Error 2

      • DezB
    2. Replies
      2
      Views
      330
      2
    3. DezB

    1. VLOOKUP does not return the correct values 1

      • mmills@itt-tech
    2. Replies
      1
      Views
      915
      1
    3. crushdrinker06

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

      • Elusive
    2. Replies
      9
      Views
      2.1k
      9
    3. sktneer

    1. Vlookup based on Range Name 9

      • mitank
    2. Replies
      9
      Views
      350
      9
    3. mitank

    1. vlookup based on date 1

      • robin a
    2. Replies
      1
      Views
      186
      1
    3. NBVC

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

      • chrismoore989
    2. Replies
      5
      Views
      730
      5
    3. NBVC

    1. Vlookup and If formula 3

      • DaveSharpe79
    2. Replies
      3
      Views
      519
      3
    3. Ingo_Ingo

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

      • ANku86
    2. Replies
      5
      Views
      8.8k
      5
    3. KjBox

    1. VLookup 6

      • JulianR
    2. Replies
      6
      Views
      402
      6
    3. JulianR

    1. 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
    2. Replies
      1
      Views
      322
      1
    3. Estevaoba

    1. Vlook up 5

      • jpetraityte
    2. Replies
      5
      Views
      899
      5
    3. jpetraityte

    1. Vertical lookup when the range changes. 8

      • JoDor
    2. Replies
      8
      Views
      1.4k
      8
    3. JoDor

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

      • Rovi
      • Rovi
    2. Replies
      8
      Views
      2.2k
      8
    3. Rovi

Label

Display Options