Right click on cell A1 and choose “Data validation”. Choose “List of items” as Criteria and enter the name of Named Ranges as comma separated values in the given field as below. In Cell B1 enter this formula. Hope you find this tutorial, i.e., how to Importrange Named Ranges in Google Sheets, worthy.
For More Information Please Refer:
You May Also Like to Read: