relative addressing

  1. P

    Relative vs absolute addressing with sheets

    I've got a spreadsheet that will have one tab/sheet per year, called (coincidentally :-) 2012, 2013, 2014, etc. I'd like the 2013 sheet to take values from the 2012 sheet, and the 2014 sheet to take values from the 2013 sheet, etc. So I created the 2012 and 2013 sheets, and on the 2013 sheet I...
  2. A

    VLookup: automatic column changes

    Please Help! I am working with a worksheet in which I have a vlookup function that needs to be drag and copied 120 columns across. At each change in column, I need the column index number, in the vlookup function, to increase by one. =vlookup($a1,B:CD,1,false) =vlookup($a1,B:CD,2,false)...

Some videos you may like

This Week's Hot Topics