Populating a column based on data from another column

Hello everyone...

Please look at the attached sheet. I need to populate column C with data from column G, based on a comparison of column F to column B.

For example, wherever there's a "100" in column B, the next cell to the right in column C should be populated with "Fail", and so on.

Columns F and G are my "key" or "legend".

My real world example is 2000 rows long so I'm looking for an automated way to do this. Can this be achieved without writing code? I think I might have done this once with a pivot table but if I did, I can't remember how to do it. Any help would be great!

Thanks a million in advance!

Peter