next value

  1. H

    Vlookup to get all the values from given dataset

    Hi Team, I hope anyone can help me with below requirement. When we do vlookup ...we only get value based on look up or same row values based on the position of the column. I need something different like need to get the values based look up and next lookup value should not be same value ...and...
  2. A

    Vlookup next value

    Hi all, I'mn probably going to do a terrible job at explaining this, but I need to write a formula to identify which city is sending freight to what postcode. Currently I have a formula(below) which can do this, however, I run into trouble when there are two different cities sending out to the...
  3. J

    vlookup with employees with the same shift

    So I have been working on a sales floor planner that pulls a ton of info onto one sheet that would be printed out every day. Part of this sheet is the schedule for the day. I have a dummy workbook showing how I am pulling data but I have a vlookup problem where if more than one person is working...
  4. J

    Finding the previous value

    In column B, I want each cell to contain a formula that is dependent on two cells from column A: the cell in the same row and the previous value above that cell. The problem is that sometimes the previous value above is one row above, sometimes two rows, three rows, etc. with blank spaces in...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top