The problem with that is that the table does not have the value to
return. The value to return is what I need to calculate a certain way
based on criteria.

Here are the possibilities in list format

This is the first set of possible choices, they are in a drop down and
return the values of 1,2,3,4,5,6,7 depending on the users choice.

TermInMonths = (12,24,36,39,48,60,63)

The second set of possible choices, which are in a seperate drop down
return the values of 1,2 depending on the users choice

LeaseType = (Fair Market Value, 1.00 Buy Out)

So as you can see you can have a lease of 1 of 2 types and it can then
be a term of 12,24,36,39,48,60 or 63 months in length

There is a table that holds the rates based on the amount being leased.
There is a seperate table of rates for leases that are under $3000.00
for both lease types and a seperate table of rates for leases $3000.00
and up for both lease types.

In summary I need to determine lease type, term length and cost
threshold, get the apropriate rate based on that criteria and then
multiply that rate by the cost of equipment.

I hope this helps everyone understand what I am trying to accomplish,
someone rescue my brain please!!

Thanks in advance!


--
dexman
------------------------------------------------------------------------
dexman's Profile: http://www.excelforum.com/member.php...o&userid=31481
View this thread: http://www.excelforum.com/showthread...hreadid=511587