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

Newbie Question - vlookup, I think
 

in C1 for your First column try this:
=IF(AND(A1="Remote",B15,B1<10),"X","")

then modify for other cells accordingly

Thanks

Newbie Question - vlookup, I think
 

You can use

=IF(A2="Remote",IF(B25,IF(B2<10,"X",IF(B2<15,"Z", ... etc.

but this is limited as to how far you can take this. Better to create two
tables like the following.

First in M1:Nn

Remote 1
Rural 2
Urban 3
etc.

The offset value will be used to build another table of lookup values, in
P1:On say, where Remote and < 5 gets a value of 1000, Remote < 10 gets 1005
(using lower bound of 5). This would then look something like

1005 X
1010 Z
1015 W
2005 A
2010 B


and then use a formula of

=VLOOKUP(VLOOKUP(A1,M1:N2,2,FALSE)*10^3+A2,O1:P5,2 )

where the text lookup is in A1, number in A2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
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