How To Use Named Ranges In Google Sheets

Your browser does not support html5 video.

How to use named ranges in google sheets. Create a named range by using google apps script. A menu will open on the right. I ve just used two funny names to name the cell cells. Named ranges allow you to use a range throughout different sheets formulas etc. This powerful feature makes google sheets a more acceptable substitute for excel for complex spreadsheets.

Vlookup e3 pricelist 3 0 this formula is the example to how to use named ranges in vlookup in google sheets. Select the cells you want to name. Select data named ranges and enter the name and reference. Open a spreadsheet in google sheets. A couple of months ago google added the ability to edit images inside presentations and google drawing.

Click on the formula cell click on data named ranges and give it a name e g. Type the name pricelist and click the button labeled as done. Select a range in the spreadsheet right click and select define named range to give it a name. Click data named ranges. Short description about named ranges you can customize the name of cell or cells using the named ranges in google doc sheets.

Your browser does not support html5 video. For example you can name the cell address a1 to hello or a range of cells like a1. I just opened a google doc and saw this nice update that allows us to edit images inside google docs. Step 2 create a named range for this cell with the string in. You can also create named ranges using google apps script.

Here is a link to the video instead. Now let me show you how to use pricelist which is the newly created named ranges in vlookup in google sheets. Step 3 combine this named range with the indirect formula to refer to this string range inside your other formulas which gives you a dynamic named range.