Help with advanced lookup

ejgallagher

Board Regular
Joined
Aug 3, 2002
Messages
123
I am helping our company do the following:

Given a persons age they fall into a certain current health plan. Using their current pricing I would like to automat a form that does the following - compares their existing price to a number of prices over several plans and finds the one closest to their own. However I need to make sure that it will hone only to their age demographic instead of simply finding that price closest to theirs which may be in another demographic. If possible, I would like to set this up to find the price below theirs - if not to move to closest above.

PLEASE HELP,

Thanks in advance -

Ed Gallagher
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Ed, your question is expressed in too broad a matter for anyone to be able to give you a good answer. Please present an example of your worksheet, then, state what you want by showing the final results wanted, along with your rules for obtaining those results. Do present the orderly arrangement you want, and not let it up to one of us to do this for you, as there can be any number of possible arrangements, only one of which will fit your needs.
 

Forum statistics

Threads
1,136,613
Messages
5,676,813
Members
419,652
Latest member
jjakub33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top