Try this:

=LOOKUP(G1,{0,74,100},{"RUN RATE","COMMS","AGED WIP"})