The request here is straightforward, and the answer matters more than most people realize. Yes, Excel can pull live data from the web, but the real question is whether you should rely on it for something as critical as a master parts table. The user asking this is not looking for a hack; they are looking for a dependable workflow. That distinction is everything.
What this means in practical terms is that Excel's built-in tools like Power Query or the older Web Content connector can absolutely fetch a page, extract the relevant part number, and refresh it on demand. The user's example of BF988 returning P553004 is exactly the kind of lookup that these tools handle. However, scraping a third-party site like the one shown in their screenshot comes with real caveats. If the site changes its layout, the query breaks. If the site blocks automated requests, the refresh fails. If the site goes down, your master data goes silent. You are not building a solution; you are building a dependency on someone else's webpage.
The better path, and the one we would advocate for, is to treat this as a data integration problem rather than a scraping problem. The user already has a structured spreadsheet with part numbers. The next step is to ask the source site whether they offer an API or a downloadable CSV of equivalents. That is a far more stable foundation. If that is not available, then a manual lookup table, maintained periodically, is still more reliable than a live scrape of a page you do not control. It is less glamorous, but it will not fail on a Tuesday afternoon when you need the answer most.
The user's instinct to automate is sound. The mistake would be to confuse automation with accuracy. Excel is a powerful tool, but it is not a magic wand that turns an unstable web page into a trustworthy database. The right move is to test the web query with a handful of part numbers, check the refresh behavior, and then make a judgment call about whether the site's reliability matches your business's need for consistency. If it does not, build the lookup table manually or find a more structured data source. That is not a compromise; that is engineering.