How to search for a value in Excel and return the number next to it.

Yes, it's a VLOOKUP. A great function in Excel that allows you to search a different table.

If you want to find data in another table, but search on something like name or company name and return values in the same row but a different cell, it's a great way to achieve this.