Perhaps this will help:

If you are using Excel 365: =FILTER(Sheet1!B$1:B$5,Sheet1!A$1:A$5=A1)

If you are using an older version: =INDEX(Sheet1!B$1:B$5,MATCH(A1,Sheet1!A$1:A$5,0))

Note: Be sure that the terms on both sheets are the same for example "susp max" on Sheet1 is not the same as "sups max" on Sheet2.