\1
What I need to do, is find the matching entry from C35:C39 that corresponds to the matching item from A23:A32, and then divide the corresponding value from B23:B32 by the corresponding value from D35:D39, and put the result in E35:E39. I can do this with a long, tedious series of nested IF statements, but I was wondering if there is a way to do this type of calculation with ranges. I'm not sure how it could be done, but I figure there are people here that are smarter than I am.

A shortened version of the nested IF statement is visible in the formula bar above, which might help you figure out more plainly what it is I'm trying to do.

Ex: ABUTLER from the C column corresponds to ABUTLER from the A column, so I need to take the corredsponding sales tracking calculation and divide it by his sales goal to see a percentage. 41218.46/60000 are his specific numbers. The reason I have to do a range, is that the names/data are not always imported in any specific order. The data at the bottom is static, but the data in rows 23-32 may be reordered randomly.

Thanks in advance!