Seek, and you will find it

"There is nothing like looking, if you want to find something. You certainly usually find something, if you look, but it is not always quite the something you were after."

R.R.Tolkien, Hobbit

Last week we finished our experiments on data validation step. We have used for that purpose column of a supporting table. In this and next posts I would like to explain some methods, you can use to search tables and merge data between.

.

Another dimension

Last week I wrote about basics of table creation. We have learned about useful CTRL+L shortcut, which creates table from range of cells. We have seed how calculated columns help to keep consistency in formulas, and how table references make them easy to understand.
It's time to harness tables to do something more useful. Let's give them additional dimension, using data validation.