Quote Originally Posted by RChad View Post
Hi,

Perhaps a tiered minimum situation can apply.

By using this formula the points can be awarded. If you need something more elaborate you may need to attach a workbook stating your criteria.

The formula for finding the points:

Formula: copy to clipboard

=VLOOKUP(G3,$C$4:$D$10,2,TRUE)


I hope this helps
I absolutely do not understand how to use this formula, im so sorry. Im not kidding when i say i know NOTHING of excel. Thank you for tour fast reply though!