Any information that can help to standardize the calculation template?

Hi guys.

First and foremost, english is not my language, hence, sorry for not explaining very well.

To start this.

1. I am building a standard calculator that calculates things when inputting or selecting a drop down.

Format:

Market - Data Validation

Direction - Data Validation (Buy/Sell)

Quantity - Manual Input

Price - Manual Input

Gross - Excel formula

Charges/Fees - Excel Formula

Net - Excel Formula

Note that for fee it should be capturing the description from the below table.

1. Now, within the above, I have the list of fees incorporated in a different settings but those fees sometimes contains different condition.

Table Sample:

Market | Fee ID | Condition | Description | Rate/Amount

X | Fee1 | Buy | VAT | xx

Y | Fee2 | n/a | Tax | xx

Y | Fee2 | n/a | VAT | xx

Y | Fee2 | Sell | Tax | xx

My goal is to create standard format when I click a dropdown (Market, Fee, Direction), it will pull out the necessary table as a break down to calculate the NET.

Currently, I am having trouble on how I can present the charges and the condition in the standard format because there are a lot of condition and description for Fee.

I have a matrix table that I can use for VLOOKUP but I am not sure if it works.

1 2 3 4

X 0 0 .4 .5

Y .2 .3 .4 .5

Z .3 .5 0 0

VBA or Macro is welcome too and I am still learning on this which I think much easier to do instead of EXCEL.

Do you have any idea on creating this template? I am keen to any guide or learning module on this.

Thank you so much for your help and apologies if it is not understandable.