Insert value in cell, from table if the search cell value matches a value found in table

Dear All

I think that this is a vlookup function, but my stringing together of the logic is not working.

Please see the attached test excel

The aim of the excel is to get the overall hours resourced to a staff member per RFP code. This will be displayed on Sheet: Staff Hrs List.

My scenario is as follows:

In Sheet: RFPs, I need to insert a value into cell A5, using the value in cell B5(still on Sheet:RFPs) as the search criteria.

The search area for the required value for A5 is on Sheet:RFP List&Codes.

Sheet:RFP List&Codes has a table with two columns. Values in column B match that of Sheet: RFPs. Column C has the corresponding required value that needs to goo into Sheet: RFPs.

I have inserted a vlookup formula into cell A5 but I dont understand why its not working.

Any assistance from a forum dweller will be much appreciated.

if I followed your explanation correctly, maybe this in Sheet1 A1... =VLOOKUP(B1,Sheet2!A:B,2,FALSE)