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
|