在工作表1，单元格A2中查找工作表2列A中包含的数字，并从工作表2列B返回一个值

As the title states, I'm looking to set up a spreadsheet where I search the text in cell A2 on sheet 1, for a multiple digit number in column A in sheet 2, and return a corresponding value from Column B in sheet 2. I've tried a few search, if, match and vlookup formulas with no luck. Any help?As the title states, I'm looking to set up a sp