Specify exact text in an if statement

Essentially I have workbook1 where I need to return the HOURLY rate of a client based on their ID (ID is in workbook1, Rate is in workbook2).

The formula I have is

=if('Workbook2'!$G$2="HOURLY",vlookup(A19,'Workbook2'!$A:$I,9,0)) *the 9 as column index is the rate*

The formula works fine until it hits any cell with another word ex: "OT HOURLY"

Basically my question is how do I get the formula to skip other cells and populate the desired cell with the next available "HOURLY" value?
Thank you so much!

No it doesn't...

It'll return FALSE if it's hourly rate, or with a minor alteration, a blank.

=IF(Workbook2!G2="HOURLY",VLOOKUP(A19,Workbook2!$A:$I,9,0),"")

Thanks Glenn. Attached to the OP is a proper example of my problem. Thank you for pointing this out.

Try

in B4 and copy down

=INDEX('wb2'!$C$20:$C$26,AGGREGATE(15,6,(ROW($C$20:$C$26)-ROW($C$20)+1)/('wb2'!$A$20:$A$26='wb1'!$A4)/EXACT('wb2'!$B$20:$B$26,"HOURLY"),1))