Newbie Question - vlookup, I think

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

.

Relevant Pages

  • colums in xcel
    ... the data only forms 2 cells per entry so is quite small ... displayed in 2 colums on each page, thus saving space when pronting the ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • limit text entry in a range of cells
    ... I have created a range of cells with an in cell drop down-list using ... data validation. ... I am using SUMIF to total columns 1-4 based on the entry of from the ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Delete ascii character 127
    ... How do I write the code to delete ascii character 127,that will always be the ... last entry in column A? ... Number of cells in column A will vary according to ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Two cell accumulator
    ... > cells. ... What I am doing now is taking last weeks entry and ... as I make mistakes adding. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • column totals
    ... column 1 to add the amount of cells with info in them, regardless of what ... column 2 To add the amount of cells with duplicate info in them. ... Prev by Date: ...
    (microsoft.public.excel.newusers)
Loading