在单元格范围内找到值并在一定距离内返回值

I have a series of pages with "product code" fields that I am copying from my website (the original source document has been misplaced). I now have the page data in excel and need to use a formula to find the heading "Product Code" and then return the value that is under that heading. Though the headings are consistent between pages, each page is a bit different in terms of where on the page that value is.I have a series of pages with "product code" fi