Hi I have an access project where a risk calculation will give a total some total are different to the risk table.  Example some of them totaling 2.6666 other 1.5 and so on.  The problem that I have is when I relate this to the risk table I will have blank resulted since the risk table is 1 for low 2 for medium and 3 for high.  And because the total is not the same number I will return an blank result.  How can I solve this I know there is an function in excel called VLOOKUP that can be use to assign the close number is Access have something similar?