Hi Belinda

I am not sure that I understand the layout of your data table.
Would you provide an example for both what it look like in Sheet 1 and 2.
and what is the expected result.

I think either Vlookup or Index Match would be the solution.

HTH

--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Belinda7237" wrote:

I am trying to build an input calculator that will return the values based
on certain inputs.

I have an excel grid that give customer characteristics:

Customer Rating transaction amount Approval Authority Approval Level Required
Column A
7 to 10 $0 $0
6 $10,000 $10,000
5 $15,000 $25,000
4 $6,000 $31,000
3 $0 $31,000
2 $0 $31,000
1 $0 $31,000
Is there a new customer involved?

i have created a look up table that has the customer rating and the
transaction high level per tier and want to return the required approval
level in column D

my lookup table for customer level 6 is on sheet 2:

column A (answers to lookup approval)
column B (Customer level)
column C ( up to approval value)

Associate + PCA/PCM or Custom Specialist 6 $1,000
Manager + Specialist 6 $3,000
Executive + ME or CCS 6 $5,000
Approval Executive + ME or CE 6 $30,000
Senior EXECUTIVE + President 6 $60,000
Risk Executive + President 6 60+

what would the proper if formula look like?