You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.