I have two adjacent cells. The contents of them combined mean that the
entry falls into a particular category e.g.

Column A Column B
Remote 4
Less Remote 10
Rural 25
Urban 15
Rural 8
Remote 6

If column A = Remote and Column B = 5 <10

then location is category X and gets so much funding


If column A = Remote and Column B = 10 <15

then location is category Z and gets a different amount

Hope that is clear

My question is:

Can I use a Vlookup or something else to compare that value in Column B
to a
range of values so that the correct $$ amount is placed ib column C??

Pleasse respond to GROUP - even if your reply embarrasses me......

Thanks for your help.

PC