It's uncommon for all the data to be on one sheet when looking for information in Excel. You'll need to search over many sheets or possibly various workbooks more frequently. The good news is that there are multiple ways to accomplish this in Microsoft Excel, but the bad news is that each one is a little more difficult to use than a standard VLOOKUP formula. But if we have a little patience, we can solve them:)
Microsoft VLookUp:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1