Hi,

This looks like a VLookup answer with a True as the last argument. See:
http://www.useexcel.com/vlookup.aspx
for an example using commission.