Hello
Not sure if the above solved your problem but if you want to insert multiple rows you can still use the insert row function.
If you want 10 rows inserting you can highlight a column of 10 cells below where you want the new rows and then use the insert sheet rows from the ribbon.
Or...
Hello
I am having trouble searching for multiple text strings in a list and returning the correct text string if it appears.
I have a reference list as below
Reference List
London
Cardiff
Exeter
Bristol
And a data list
Data List
London
Cardiff City Centre
City of London...