For each if then issues

I have attached a spreadsheet with a small set of sample data. I am wanting to write a macro that will plug in the commission rate in col C on sheet Data based on the person sales from col B using the table listed on sheet Rate table.
I was thinking the best answer for this would be a for each/if then style macro. I know i could use a vlookup to do this and it is what i am currently doing however the amount of data I am needing to do this for and the number of times i have to do this each day i think the macro answer is better so if you guys could help that would be great. I have no experience writing a for each macro as i have only just started my macro side of excel.

Thanks for all the help