Here is the formula for cell G2:
Here is the formula for cell H2:
You can now drag your formulas down to finish. Vlookup formulae are really helpful, and I suggest researching how they work because someone else might be able to describe it better than I can. In essence, you are looking up a value (column F) in an array (columns A, B, C), and if a match is found, you return a column index (B = 2, C = 3, etc.). Last but not least, you are searching for a close (TRUE) or exact (FALSE) match. Apply FALSE almost always.
Additionally, research cell references and how to lock them (including the various $ sign rules). By maintaining the same lookup value and array, you may quickly drag formulas across the page.