Looks up options

Hi Andrea

Thank you for your questions.

I have pulled together some information for Match and Index for you from our forum:
https://www.stl-training.co.uk/article-1621-learn-how-use-index-and-match-functions-in-excel.html

Ranges can be defined on the formulas tab. They allow you to refer to a cell or block of cells by name in your formulas.

We have a blog article on the subject here.
https://www.stl-training.co.uk/b/blog/excel-training/using-named-ranges-and-the-name-manager/

Rather than manually setting or adjusting ranges it is possible to create ranges that automatically include new data when added to the sheet.

Here is a great page about dynamic ranges using offset:
https://support.microsoft.com/en-us/kb/830287

I hope this is helpful - let me know if you have any further questions.

Kind regards,
Andrew