R
Ryk
Ok, first timer here, though have recieved alot of help with a project
I am working on from examples from here. I have almost complete a
project, but am stuck one the one thing we most hope this can do. We
are trying to make a program that takes mobile phone usage, and based
on usage suggests a plan too use. We are unsure how to make vlookup
look through several hundred plans, and suggest anything based on
usage. We have used index and match and have it so it suggests all
plans that fit, we need it to be specific down too one plan each time.
So question is, how can we have it set too look at Total Mins, pick as
many that fit, then have it narrow the field with Used Mins, then again
narrow the field with Off peak mins etc, until it finds the exact best
fit? We have a page that has all plans with Mins used, Plans Total
mins, if it has weekends or nights etc totalling about 14 columns of
data it needs go through. I need it too work in one formula so I can
drag it down so it can do several numbers at once, indexing that so it
moves the suggestions to a main page we have setup. Unsure if I have
provided enough info, glad to supply and missing info if needed.
Many thanks....Ryk
I am working on from examples from here. I have almost complete a
project, but am stuck one the one thing we most hope this can do. We
are trying to make a program that takes mobile phone usage, and based
on usage suggests a plan too use. We are unsure how to make vlookup
look through several hundred plans, and suggest anything based on
usage. We have used index and match and have it so it suggests all
plans that fit, we need it to be specific down too one plan each time.
So question is, how can we have it set too look at Total Mins, pick as
many that fit, then have it narrow the field with Used Mins, then again
narrow the field with Off peak mins etc, until it finds the exact best
fit? We have a page that has all plans with Mins used, Plans Total
mins, if it has weekends or nights etc totalling about 14 columns of
data it needs go through. I need it too work in one formula so I can
drag it down so it can do several numbers at once, indexing that so it
moves the suggestions to a main page we have setup. Unsure if I have
provided enough info, glad to supply and missing info if needed.
Many thanks....Ryk