I got the below data that I need to find the ultimate result after comparing
multiple logical_tests. I had tried using IF, OR, AND, MATCH command, but to
no avail.
Hope some of you can give me some suggestion as to what other command that I
should be using.

The data as follows :

## QUOTE ##
Transactional size limit = USD1 mio
-----------------------------------------
Buyer1

Transactional size limit = USD750K
----------------------------------------
Buyer2
Buyer3

Transactional size limit = USD500K
----------------------------------------
Buyer4
Buyer5
Buyer6

Remark 1 : The above shows the individual buyer being categorise with the
different transactional size limit.

Remark 2 : Only the listed buyer names are allow
## UNQUOTE ##


To start, I will input 2 information in the spreadsheet i.e. :

1. Buyer name
2. Application amount

Now I need to formulate a formula which will :

1. Check the buyer name is match
2. If buyer name not match, to highlight "Buyer not in approved list"
2. If match, then proceed to check the application amount i.e. whether less
or equal to the allocated individual transactional limit
3. If amount larger than the allocated transactional limit, to highlight as
"Amount Excess", else, to highlight as "Transactional amount within"


Based on the above, I hope somebody can help me.

This is really pain in the neck for me, cause had tried many ways to do it.
Unless, I can formulate a formula, else, I will need to do manual checking
everytime I doing the transaction, and hopefully not oversight anything in
the process.

Lastly, sorry for the lengthy data.

Many thanks in advanced
Stephen Lim