You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
It's easy to merge cells in Google Sheets using a computer or the Google Sheets mobile app. Here's how to do it.