Re: Newbie Question - vlookup, I think
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Jan 2006 10:07:03 -0000
You can use
=IF(A2="Remote",IF(B2>5,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)
<caseyp_l@xxxxxxxxxxx> wrote in message
news:1136450348.942870.244870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- Newbie Question - vlookup, I think
- From: caseyp_l
- Newbie Question - vlookup, I think
- Prev by Date: Re: Convert a string value to numeric and sort
- Next by Date: Re: create function with passing parameters
- Previous by thread: Re: Newbie Question - vlookup, I think
- Next by thread: User Defined formula, selecting range
- Index(es):
Relevant Pages
|
