I have been using vlookup since 1995. Over the last few weeks I have not been getting the results I have expected and have discovered that copying the formula down, now changes the table array.
In the past I have always dragged or double clicked the formula down to the bottom of my selection...
I am setting up a spreadsheet to record payments in a work lotto.
Names of each participant are in a column, dates due are in the heading row.
As payment is made a Y is entered into the corresponding cell.
I would like to show when each person paid up to - my thinking was to use a formula to...