formula for returning value from a list

[GREGRACH]

Hi All, I am trying to add a formula and can't quite get it.

I have two sheets in a workbook. In Sheet1, if the text in cell E12 matches the text from Sheet2 cell range A2:A18, I want Sheet1 cell E13 to return the value from the column range Sheet2 B2:B16.

So I want to select the crane in Sheet1 from the drop down list from Sheet2 and returning the crane weight.

Any help would be greatly appreciated! I have attached screen shots.

Thank you.

 

[GREGRACH]

Sorry correction, if the text in Cell E11 in sheet 1 matches Sheet 2 range, not text in E12, apologies.

 

[Fluff]

How about
=VLOOKUP(E11,Sheet2!$A$2:$B$18,2,0)

 

[GREGRACH]

How about
=VLOOKUP(E11,Sheet2!$A$2:$B$18,2,0)

Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback