A

B

C

D

E

F

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$,$This value does no;$,$exist,$]]$

$2$ Laptop

$3$ TV

$4$ Cell Phone

$5$ TV

$6$ Laptop