A

B

C

D

E

F

G

H

Use the VLOOKUP function in D$5$ and E$5$ to populate the item price and item tax.

Next, in Cell f$5,$ calculate the Order Total in one formula $($Order Total is Item Price $+$ the Amount of Tax Assessed$).$

$\backslash$table$[[$OrderID$,$Product,$\backslash$table$[[$Item Price $($Use$],[$Vlookup to Get$],[$Item Price$)]],\backslash$table$[[$Item Tax Rate $($Use$],[$Vlookup to Get Tax$],[$Rate$)]],\backslash$table$[[$Order Total $($Write$],[$Formula to Calculate$],[$Order Total$]]],[1,$TV$,,,],[2,$Laptop,,,$],[3,$TV$,,,],[4,$Cell Phone,,,$],[5,$TV$,,,],[6,$Laptop,,,$]]$

A

B

C

D

E

F

G

H

Use the VLOOKUP function in D$5$ and E$5$ to populate the item price and item tax.

Next, in Cell f$5,$ calculate the Order Total in one formula $($Order Total is Item Price $+$ the Amount of Tax Assessed$).$

$\backslash$table$[[$OrderID$,$Product,$\backslash$table$[[$Item Price $($Use$],[$Vlookup to Get$],[$Item Price$)]],\backslash$table$[[$Item Tax Rate $($Use$],[$Vlookup to Get Tax$],[$Rate$)]],\backslash$table$[[$Order Total $($Write$],[$Formula to Calculate$],[$Order Total$]]],[1,$TV$,,,],[2,$Laptop,,,$],[3,$TV$,,,],[4,$Cell Phone,,,$],[5,$TV$,,,],[6,$Laptop,,,$]]$

$\backslash$table$[[,$Discount,Tax Tax Rate,Item Price$],[$Cell Phone,$6\%,8\%,600],[$TV$,4\%,10\%,450],[$Laptop$,1\%,9\%,750]]$