A key skill in Excel training is to be able to lookup and retrieve data from a range of records. The most popular way of achieving this is to use the VLOOKUP function. The VLOOKUP function in Excel is awesome and easy to use, but it has its drawbacks. Cue the Excel DGET function.

A very powerful Excel function that will retrieve data from a record without the limitations of VLOOKUP. Advantages of using the DGET function include:

• It can retrieve data from a column to the left of the column you searched within.
• It can lookup data based on multiple conditions.
• It can handle both AND and OR logic.

The Formula

If you wish to protect the cells on a worksheet that contain formulas you will need to lock the cells first, whilst also ensuring that the cells users should be able to change are unlocked.

It may have been a while since you worked on this worksheet and you are not sure which cells are locked and which are not. You need a fast method of locating the locked cells. Let’s use Conditional Formatting to highlight the cells that are already locked so they are easy to identify.

The CELL function in Excel is very powerful and relatively unknown to many. Use the Excel CELL function to return information about a cell. This can include the cell’s number format, row number or whether it is locked or protected.

There are times when this kind of functionality becomes extremely useful. Especially while Excel does not provide many other means of finding the number format of a cell, or whether it has been locked.