Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Newbie Question | Excel Worksheet Functions | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
vlookup (newbie, STILL) | New Users to Excel | |||
VLookup, Max??? Newbie | Excel Programming |