enter image description here

Hi, so I want to find the name of the Treasury Manager in Column B. However, there are 1500 names and I have shown only 2

I want to use Google search to directly post the name itself. I have read that the =INDEX(IMPORTXML()) function would help but I have no idea how to use it

Any help would be gladly appreciated