Lookup Cell (Text) in a Range and Return Value from a Corresponding Column

[sea_captain]

Hola - need help solving a formula, that seems simple, yet i'm struggling to get the result i need.
I need to solve for the 'New Column' by Matching the Project in Tab1 with the Project (Range) in Tab 2 and returning Hours from Tab 1
Any help appreciated. -sc

 

[Scott Huish]

Assuming your values on Sheet1 are in A:B, and Column A on Sheet2

=ISNUMBER(MATCH(A2,Sheet2!A:A,0))*B2

Copy down.

 

[sea_captain]

thanks, i'll try it

 

[sea_captain]

Assuming your values on Sheet1 are in A:B, and Column A on Sheet2

=ISNUMBER(MATCH(A2,Sheet2!A:A,0))*B2

Copy down.

That worked, Thanks! Marked as 'solution'