Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryk Ryk is offline
external usenet poster
 
Posts: 36
Default Minor/Major dilemma...

Am trying to make the following example, compare to what a person has
now, and be able to enter their usage and have it suggest a plan that
best fits needs. I have a database of plans made and I'd guess I
need a rather complicated VLOOKUP or array, but am rather new to excel,
learning as I go. What it needs look through is as follows...

Monthly Rate, Regular Minutes, Night Minutes, Weekend Minutes, Mobile
to Mobile Minutes

I might need to add some extra variables, but need this data too end up
suggesting a better fit, based on cost and usage, and have the answer
come out on the right, so I can index it, and send it to a new sheet I
have setup to present to the user if changes are needed. I'd like to
be able to drag formula down so if user has more than line, it auto
populates the suggestion sheet.

I'll leave it to the gurus, and my thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Major and minor gridlines on logarithmic axis excel 2007 Vincent Excel Discussion (Misc queries) 7 September 10th 09 03:59 PM
Major and minor gridlines on logarithmic axis excel 2007 Vincent Charts and Charting in Excel 7 September 10th 09 03:59 PM
minor and major gridlines rafi Charts and Charting in Excel 4 May 29th 09 10:21 PM
ScatterPlot Major and Minor Horizontal Gridlines not showing bfschuil Charts and Charting in Excel 3 September 19th 07 07:42 PM
MAJOR Worksheet Dilemma Sandi Excel Worksheet Functions 4 August 11th 06 12:44 PM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"