sheets / excel look up value by "submission number" return "name" : I have one sheet, with values such as this: 

**Sheet A**

[![enter image description here][1]][1]

    
another sheet with values like so: 

**Sheet B**

[![enter image description here][2]][2]


What I would like to do is search in the **Sheet A** by "Submission Number", i.e. the values in cell `A`, I want to search there using the values in cell `B` of **Sheet B** and return the *Name* of the company, the value in **Sheet A**, cell `B`. 

I was trying something like this but it didn't work:

    =LOOKUP(B2, eligible.submissions!B2:B160,1,1)

So in the example above, for row `1` in **Sheet B** I want to use the value `724`, i.e. (**Sheet B**, column `B`, row 1), to look in the Column `A` of **Sheet A**, there I would find that `724` corresponds to "*Advice Business Development*", and accordingly I want my function to return me that value, the name. 

Is this possible with Google sheets or excel? 

Which function to use? 

I was also trying something like this:


    =LOOKUP(B2, SheetA!B2:B160,SheetA!B2)


  [1]: http://i.stack.imgur.com/hghYX.png
  [2]: http://i.stack.imgur.com/Ghi5H.png