excel - Search Sheet 1, Cell A2 for a number contained in Sheet 2 column A and return a value from Sheet 2 Column B -

as title states, i'm looking set spreadsheet search text in cell a2 on sheet 1, multiple digit number in column in sheet 2, , return corresponding value column b in sheet 2. i've tried few search, if, match , vlookup formulas no luck. help?

i use like

=index('sheet 2'b:b, match('sheet1'a2, 'sheet2'a:a, 0)) 

you may have add quotes in, don't know why disappear when copy/paste.