Each cell in a worksheet has a unique reference that describes its position – for example A1. In a spreadsheet, there are two types of cell reference – 'relative cell reference' and 'absolute cell ...

At the conclusion of Part 2, I showed you a screen capture of a spreadsheet in which I looked up values from elsewhere in the spreadsheet. Some of these values were retrieved without issue, but others ...