srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,851
- Office Version
- 365
- Platform
- Windows
I have invoice amounts in column A and approvers names on corresponding cell in column B, we have more than one approvers depending on the amount in column B.
I arranged the approvers names in column C and the upper limit of amount they can approve in corresponding column D. the last name in the list does not have upper limit, so there is no amount.
I am looking for a formula that sees the amount in column B, MATCH it with upper the limit in Column D and fetch the name from column C. (I can switch the names and amount in column C and D).
I can do it with =IF(AND formula, but there are more than one approvers so I think I will need, INDEX AND MATCH formula with 1.
Please advise.
I arranged the approvers names in column C and the upper limit of amount they can approve in corresponding column D. the last name in the list does not have upper limit, so there is no amount.
I am looking for a formula that sees the amount in column B, MATCH it with upper the limit in Column D and fetch the name from column C. (I can switch the names and amount in column C and D).
I can do it with =IF(AND formula, but there are more than one approvers so I think I will need, INDEX AND MATCH formula with 1.
Please advise.